Re: [HACKERS] SET CONSTRAINTS and like named constraints

2003-09-04 Thread Bruce Momjian
Stephan Szabo wrote: > On Thu, 4 Sep 2003, Bruce Momjian wrote: > > > 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 fai

Re: [HACKERS] SET CONSTRAINTS and like named constraints

2003-09-04 Thread Stephan Szabo
On Thu, 4 Sep 2003, Bruce Momjian wrote: > 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 defer

Re: [HACKERS] SET CONSTRAINTS and like named constraints

2003-09-04 Thread Bruce Momjian
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

[HACKERS] SET CONSTRAINTS and like named constraints

2003-08-16 Thread Stephan Szabo
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 deferr