| 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: | Whole Thread | Raw Message | 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 |