Rod Taylor <rbt(at)rbt(dot)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