Re: Sequences/defaults and pg_dump

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: PostgreSQL-general general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Sequences/defaults and pg_dump
Date: 2006-02-07 16:01:07
Message-ID: cafd57251379d4c209b215cc75f3f19d@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Tom Lane wrote:

> The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
> a serial column, but we haven't gotten around to enforcing that yet.

Is this per the Standard? If so, then the oft-repeated mantra that
SERIAL is simply a macro for an INTEGER column with a particular
DEFAULT seems a bit misleading ...

- John D. Burger
MITRE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-02-07 16:19:18 Re: Sequences/defaults and pg_dump
Previous Message Benjamin Arai 2006-02-07 15:59:33 Syncing Databases Weekly

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-07 16:01:21 Re: Actual expression of a constraint
Previous Message Andrew Rawnsley 2006-02-07 15:58:36 Re: streamlined standby procedure