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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
