On Mon, 2006-07-03 at 11:14 +0000, james wrote:
> i think it's a bug in postgresql ...
Primary Key constraints are not deferrable currently. This is a known
situation so this isn't a bug.
I would advise you not to update the PK of your tables. That usually
represents a modelling problem and so I'm not sure if people will spend
time on trying to make that work.
Use an indirect key or some other mechanism, such as Inserting into
another table and renaming them.
In response to
pgsql-bugs by date
|Next:||From: Tomasz Ostrowski||Date: 2006-07-03 20:31:07|
|Subject: query very slow when enable_seqscan=on|
|Previous:||From: Phil Frost||Date: 2006-07-03 18:19:09|
|Subject: BUG #2512: pg_dump produces unrestorable output when table and serial sequence are not in the same schema|