Re: Check RI on Commit

Dag Arne Matre <dam_at_visma.com> writes:

>I believe there is an option in ANSI-SQL (don't know whether it is SQL2
>or the SQL3 proposal, don't know which level) that says: wait for commit
>to check referential integrity. Normally, this would fail:
>INSERT INTO Detail (DetailPK, MasterPK) values (1,1)
>INSERT INTO Master (MasterPK) values (1)
>COMMIT
>but with the option set, it would be OK.
>Basically, this means that you can do whatever you want inside your
>transaction, just make sure the db is consistent when you COMMIT your
>WORK.
Oracle8 introduces the concept of deferred constraint checking, in which integrity constraints are not checked until the transaction ends. See Oracle Concepts, chapter 23 pp 19.

--

Nathan D. Hughes <nhughes_at_well.com>
Senior Consultant, Custom Business Solutions, Inc.