Re: set constraints behavior

On Fri, 3 May 2002, Neil Conway wrote:

> Hi all,
>
> The SQL92 spec has this to say about SET CONSTRAINTS DEFERRED:
>
>     a) If ALL is specified, then the constraint mode in TXN of all
>        constraints that are DEFERRABLE is set to deferred.
>
>     b) Otherwise, the constraint mode in TXN for the constraints
>        identified by the <constraint name>s in the <constraint name
>        list> is set to deferred.
>
> (section 14.2, page 401)
>
> My reading of this: if you specify ALL, only the constraints marked
> as DEFERRABLE are affected. If you specify a specific constraint,
> it is deferred, whether the constraint is marked as DEFERRABLE or
> not.
>
> Current Postgres behavior is incompatible with this interpretation:

I think you missed Syntax Rule 2:
"The constraint specified by <constraint name> shall be DEFERRABLE"