In 8.4, the sequence value is copied only when INCLUDING DEFAULTS is specified. Otherwise, only the not null constraint is copied. I think this is the most reasonable behavior and I don't see why it should have been explicitly stated in the manual.
On Fri, Oct 30, 2009 at 8:44 AM, Mark Morgan Lloyd <markmll.pgsql-gene...@telemetry.co.uk> wrote: > What is the "correct" behavior of a serial column when a table is created > with LIKE? The manual is silent on this. > > What appears to be happening with 8.2 is that the column in the new table > refers to the original sequence generator. > > -- > Mark Morgan Lloyd > markMLl .AT. telemetry.co .DOT. uk > > [Opinions above are the author's, not those of his employers or colleagues] > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
