Re: Oversight? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Oversight?
Date
Msg-id 26894.1060643776@sss.pgh.pa.us
Whole thread Raw
In response to Oversight?  (Rod Taylor <rbt@rbt.ca>)
Responses Re: Oversight?
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: new psql \d command
Next
From: Tom Lane
Date:
Subject: Re: sql99 compat list