Re: Oversight?

Rod Taylor <rbt@rbt.ca> writes:
> 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.
        regards, tom lane