Bug? change from 8.0 to 8.2rc1 in checking default expressions

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.

Browse pgsql-bugs by date

  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