Re: Sequences/defaults and pg_dump - Mailing list pgsql-general

From John D. Burger
Subject Re: Sequences/defaults and pg_dump
Date
Msg-id cafd57251379d4c209b215cc75f3f19d@mitre.org
Whole thread Raw
In response to Re: Sequences/defaults and pg_dump  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Responses Re: Sequences/defaults and pg_dump
Re: Sequences/defaults and pg_dump
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequences/defaults and pg_dump
Next
From: "Benjamin Arai"
Date:
Subject: Syncing Databases Weekly