Thread

pgdump and sequences

Brook Milligan <brook@trillium.nmsu.edu> — 1999-01-10T02:50:50Z

I've just migrated a database to 6.4.2 and was looking at the new
pgdump output.  It looks much better than earlier versions, but it
doesn't seem to include any information about sequences created
implicitly via the serial datatype.  Pgdump describes the field as one
might have before (e.g., int4 default nextval (table_id_seq)), but the
sequence is never created.  As a result, the script seems unable to
recreate the state of the database.

What is required to fix this?  Should this be a TODO item?

Cheers,
Brook