Re: Oversight? - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Oversight?
Date
Msg-id Pine.LNX.4.33.0308120846370.3756-100000@css120.ihs.com
Whole thread Raw
In response to Re: Oversight?  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Farewell
Next
From: Tom Lane
Date:
Subject: Re: reuse sysids security hole?