Re: Cascading updates to FKs with unique constraints

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: sfpug(at)postgresql(dot)org
Cc: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
Subject: Re: Cascading updates to FKs with unique constraints
Date: 2006-03-03 18:45:41
Message-ID: 200603031045.41406.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Brian,

> I think the answer is no, but thought one of the gurus on the list might
> have a more creative answer. Thanks!

You're right. There's really no way around it except running an update on
each dependant table.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2006-03-06 21:04:59 March Meeting?
Previous Message David Fetter 2006-03-03 02:12:23 Re: Cascading updates to FKs with unique constraints