On Tue, 2009-07-28 at 22:10 +0100, Dean Rasheed wrote: > Hmm, yes, looking in the SQL spec, I've just noticed this under 11.8, > referential constraint definition: > > "The table constraint descriptor describing the <unique constraint > definition> whose <unique column list> identifies the referenced > columns shall indicate that the unique constraint is not deferrable." > > which seems like a sensible policy now that I think about it.
Is it a problem to allow unique constraints to be deferrable until the end of the command though? To meet the spec, "SET i = i + 1" should work even if "i" is referenced by a FK. Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers