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: How to ensure data consistency?

Re: How to ensure data consistency?

From: Felix E. Klee <felix.klee_at_inka.de>
Date: Thu, 9 Sep 2004 01:54:43 +0200
Message-ID: <20040909015443.7bcdede7.felix.klee@inka.de>


On 8 Sep 2004 02:35:39 -0700 Tony Andrews wrote:
> As Dan says elsewhere, the 2-way foreign keys will work if your DBMS
> allows constraint checking to be deferred until you commit the
> transaction:
>
> [...]

Thanks. Similar code worked fine (in posgreSQL). As a newbie to databases I didn't know this simple solution.

Felix Received on Wed Sep 08 2004 - 18:54:43 CDT

Original text of this message

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