Re: SQL deferred constraints (a bit O/T, I know)
From: Erwin <e.smout_at_myonline.be>
Date: Mon, 4 Apr 2011 05:11:20 -0700 (PDT)
Message-ID: <ae702309-20d7-4669-b6f2-ab2b357f0461_at_f18g2000yqd.googlegroups.com>
Date: Mon, 4 Apr 2011 05:11:20 -0700 (PDT)
Message-ID: <ae702309-20d7-4669-b6f2-ab2b357f0461_at_f18g2000yqd.googlegroups.com>
On 4 apr, 07:38, David BL <davi..._at_iinet.net.au> wrote:
> On Apr 2, 11:21 pm, Erwin <e.sm..._at_myonline.be> wrote:
>
> > This has been documented before. MVCC and database constraint
> > checking do not fit together.
>
> I thought in normal practice only read only transactions access old
> versions so MVCC doesn't upset constraint checking at all.
Yes. That is probably because DBMS builders are quite aware of the problem.
The OP, however, didn't seem to be (as also evidenced by his own reply). Received on Mon Apr 04 2011 - 14:11:20 CEST