From: | "Mischa Sandberg" <mischas(at)ca(dot)sophos(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Bug? change from 8.0 to 8.2rc1 in checking default expressions |
Date: | 2006-11-30 21:14:08 |
Message-ID: | DCED23B198FFA144A0398D9CE4C4A6AD85C57E@ca-exchange.activestate.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Haile | 2006-11-30 21:15:30 | Re: fsync and semctl errors with 8.1.5/win32 |
Previous Message | Jeremy Haile | 2006-11-30 17:11:34 | Re: BUG #2795: can't start service postgre |