Re: Disabling check constraints

From: Thomas Kellerer <TAAXADSCBIXW_at_spammotel.com>
Date: Tue, 17 Oct 2006 10:18:52 +0200
Message-ID: <4pjhvcFiiv4dU1@individual.net>

On 17.10.2006 09:58 Alex wrote:
> Oracle version is 9.2 but I'm looking for something that works with any
> version...
> I need to update some key values on tables that have Foreign Key
> Constraints.
> What should I do?
>
> I don't know exactly what's the problem... DBMS returns this error
> message: "integrity constraint violated - child record found" when I
> try to update the key value on a parent table. So I want to disable
> that I call "check" on foreign key constraints.

What about my suggestion about setting the constraints to deferrable/initially deferred, so that they will be validated at the end of the transaction?

Thomas Received on Tue Oct 17 2006 - 03:18:52 CDT