On Tue, 12 Aug 2003, Christopher Kings-Lynne wrote: > > > 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. > > I assume his point is "how do we set all of a user's constraints deferred by > default"?
But constraints aren't really per user, are they? I can see wanting to set all of a table's contraints / dependent table constraints to deferred, but a user's constraints doesn't make much sense to me. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])