Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: when are check() constraints evaluated

Re: when are check() constraints evaluated

From: Mike Sherrill <MSherrillnonono_at_compuserve.com>
Date: Tue, 23 Dec 2003 10:01:31 -0500
Message-ID: <qpkeuvcr0ghptqn7shtq1nn93e9q1o9jp9@4ax.com>


On 22 Dec 2003 11:24:34 -0800, karelvdwalt_at_webmail.co.za (Karel van der Walt) wrote:

>I am specifically interested in table invariants

The relational model and the SQL standard support deferred constraint checking, in which the constraints are evaluated at the end of a transaction. But not all vendors have implemented support for deferred constraints yet.

-- 
Mike Sherrill
Information Management Systems
Received on Tue Dec 23 2003 - 09:01:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US