Re: Deferred uniqueness versus foreign keys

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