Re: Oversight?

On Tue, 12 Aug 2003, Christopher Kings-Lynne wrote:

> > > rbt=3D# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED;
> > > ERROR:  syntax error at or near "ALL" at character 32
> > > rbt=3D# ALTER USER rbt SET CONSTRAINTS =3D DEFERRED;
> > > ERROR:  "constraints" is not a recognized option
> >
> > "SET CONSTRAINTS ALL DEFERRED" is a SQL-spec-mandated command syntax.
> > Any similarity to Postgres' "SET var = value" syntax ends with the
> > initial keyword.
>
> I assume his point is "how do we set all of a user's constraints deferred by
> default"?

I don't think that'd make all of a user's constraints deferred, I'd think
it would make all constraints that are deferrable deferred for that
user's transactions (as if the user did a set constraints all deferred at
the beginning of every transaction).