<
< CREATE TABLE . (
< ,
< id bigint NOT NULL
< );
<
I've never seen a plaintext pg_dump output where the sequence associated with
a column in a table was not mentioned in s "DEFAULT nextval(..." modifier in
that column's line of the CREATE TABLE statement, ex:
<
< CREATE TABLE . (
If this is a development database, perhaps you can do a schema-only
pg_dump of it in plain text format, manually edit out the offending second
sequence from the resulting SQL file, and restore it into a new database.
Yours,
Kurt Reimer
From: Colin 't Hart
