From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: set constraints behavior |
Date: | 2002-05-03 18:46:30 |
Message-ID: | 20020503113452.A73122-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 3 May 2002, Neil Conway wrote:
> On Fri, 3 May 2002 10:39:28 -0700 (PDT)
> "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:
> >
> > On Fri, 3 May 2002, Neil Conway wrote:
> > > My reading of this: if you specify ALL, only the constraints marked
> > > as DEFERRABLE are affected. If you specify a specific constraint,
> > > it is deferred, whether the constraint is marked as DEFERRABLE or
> > > not.
> > >
> > > Current Postgres behavior is incompatible with this interpretation:
> >
> > I think you missed Syntax Rule 2:
> > "The constraint specified by <constraint name> shall be DEFERRABLE"
>
> Ah, okay. Yeah, I missed that part. Stupid standards, they're
> practically unreadable :-)
>
> (My other question, regarding transaction and SET CONSTRAINTS,
> is still valid)
Didn't answer that part because I'm not sure what's best for that
given the way we handle "out of transaction" statements (the
other I remembered from past readings and rechecked).
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-03 19:18:26 | Re: HEADS UP: Win32/OS2/BeOS native ports |
Previous Message | Neil Conway | 2002-05-03 18:12:01 | Re: set constraints behavior |