Re: FK - automatic value change when parent changes
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 26 Feb 2010 17:13:41 +0000 (UTC)
Message-ID: <hm8vg4$rrm$1_at_news.eternal-september.org>
On Fri, 26 Feb 2010 00:36:45 -0800, eh wrote:
Date: Fri, 26 Feb 2010 17:13:41 +0000 (UTC)
Message-ID: <hm8vg4$rrm$1_at_news.eternal-september.org>
On Fri, 26 Feb 2010 00:36:45 -0800, eh wrote:
> Hi,
> we have a Fk pointing to a parent table/column - and now sadly enough
> that primary key value will change.
> What would be a smart way to implement this change to these child tables
> ?
>
> Disabling FK's and a lot of update clauses or .... ??
Redesigning the application would be the best choice, if you ask me. Public execution of the original designer which includes quartering should also be considered.
-- http://mgogala.byethost5.comReceived on Fri Feb 26 2010 - 11:13:41 CST