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.