Re: SET CONSTRAINTS and like named constraints - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: SET CONSTRAINTS and like named constraints
Date
Msg-id 200309050038.h850cpM19547@candle.pha.pa.us
Whole thread Raw
In response to SET CONSTRAINTS and like named constraints  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: SET CONSTRAINTS and like named constraints
List pgsql-hackers
Stephan Szabo wrote:
> 
> It looks like that right now if you have multiple constraints
> with the same name on different tables and some are deferrable
> and some are not, SET CONSTRAINTS "name" DEFERRED will fail when
> it reaches the not deferrable constraint. Is this the behavior
> we want, or do we want it to defer the deferrable ones with that
> name and possibly warn that some were not deferrable?

We have this TODO:
* Allow SET CONSTRAINTS to be qualified by schema/table

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats Collector Error 7.4beta1 and 7.4beta2
Next
From: Tom Lane
Date:
Subject: Re: Stats Collector Error 7.4beta1 and 7.4beta2