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.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com