Rod Taylor <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster