Did I miss this in the README? This is not so much a bug as a migration
requirement:

 

Some old schemas relied on a stupid construct for creating sequences
(hey, we all have cruft), using a table rather than a sequence to create
a sequence shared by multiple tables. 

 

Pg_dump output contains:

 

CREATE TABLE cfg_list(...

   Change_id integer DEFAULT nextval('cfg_change_id_seq') NOT NULL);

 

... followed by ...

 

CREATE TABLE cfg_change(id SERIAL, ...)

 

This worked okay in 8.0. I guess 8.2 is doing something a bit tighter,
but when I try to reload dumps such as the above, I get:

 

ERROR: relation "cfg_change_id_seq" does not exist 

 

... on the first CREATE TABLE stmt.

 

Reply via email to