Re: Needs help urgent..

From: Brian E Dick <bdick_at_cox.net>
Date: Tue, 17 Sep 2002 12:33:31 GMT
Message-ID: <viFh9.65493$8F4.1594365@news2.east.cox.net>

You are violating a basic rule of relational databases. Primary keys are immutable.

Now that you have been sufficiently scolded, I see two choices (you eliminated a third).

As another posted recommended, insert a new master, update the detail, delete the old master.
Drop the constraint and recreate it as deferrable. For more info, check the docs.

"priya" <priya_at_starcomsoftware.com> wrote in message news:1ae23258.0209162213.66a85c16_at_posting.google.com...
> Hi..
>
> I want to update two tables which have ref. integrity constraints among
them.
> When I'm updating master table's primary key it gives me error as
>
> 'Integrity constraint violated .. child record found'
>
> When I'm updating detail table's ref. key gives me error as
>
> 'Integrity constraint violated.. no parent record found'
>
> Is there any way to solve above problem other than enabling / disabling
> constraints before updattion ?
>
> Thanks,
> Priya
Received on Tue Sep 17 2002 - 07:33:31 CDT