Re: Deferred constraint checking

From: Roy Hann <specially_at_processed.almost.meat>
Date: Thu, 3 Aug 2006 11:03:41 +0100
Message-ID: <4pCdnT-AVsGMV0zZRVnygQ@pipex.net>

"vc" <boston103_at_hotmail.com> wrote in message news:1154550145.336345.135240_at_m73g2000cwd.googlegroups.com...
>
> Roy Hann wrote:
>> I've not been able to devise a sufficiently selective Google search to
>> answer this, and maybe someone here can just point me in the right
>> direction. I'm looking for information about how deferred constraint
>> checking is actually accomplished by any mainstream SQL products that
>> implement it.

> http://www.oracle.com/technology/oramag/oracle/03-nov/o63asktom.html

Thanks vc, but I think my request was insufficiently clear. What I am actually interested in is the underlying machinery that implements the described behaviour. For example, I want to know how these products track which rows will be checked when a deferred constraint is finally tested. (This might be a proprietary secret in many cases, but perhaps some of it is in the public domain, e.g. patent documents.) I would be particularly interested in the implementation details of deferred general constraints (assertions).

Roy Received on Thu Aug 03 2006 - 05:03:41 CDT