Re: Oversight?

On Mon, 2003-08-11 at 19:16, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> writes:
> > rbt=# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED;
> > ERROR:  syntax error at or near "ALL" at character 32
> > rbt=# ALTER USER rbt SET CONSTRAINTS = 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.

Yes, but we don't support 'SET constraints = deferred' either.