Re: Oversight?
От | scott.marlowe |
---|---|
Тема | Re: Oversight? |
Дата | |
Msg-id | Pine.LNX.4.33.0308120846370.3756-100000@css120.ihs.com обсуждение исходный текст |
Ответ на | Re: Oversight? ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Список | pgsql-hackers |
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.
В списке pgsql-hackers по дате отправления: