Update of foreign key values

From: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Update of foreign key values
Date: 2003-08-11 19:04:47
Message-ID: Pine.LNX.4.33.0308111100460.8612-100000@main.cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but
there are several other dependencies I have to resolve first) and I need
to update one database's tables so they can be merged into the other
database's table. I know I can drop the constraints and update the tables
(primary key, and foreign key) but was hoping I'd not have to do that.
An attempt at using the techniques in Joel Burton's "Referential
Integrity Tutorial & Hacking the Referential Integrity tables" was
unsuccessful.

Is there a method I can use to add 1000 to all the primary and foreign
keys in one pass? Searches using Google and the PostgreSQL docs turned up
nothing useful to my situation. I see if the table/constraint would have
been created differently the updates would have cascaded but that did
not happen.

TIA,
Rod
--
"Open Source Software - Sometimes you get more than you paid for..."

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Gardner 2003-08-11 19:52:40 Re: One table into two different databases
Previous Message Mike Benoit 2003-08-11 17:28:19 Re: Tsearch limitations