Postgres Pro
Downloads
Home   >   mailing lists

Re: combining db's- importing primary keys - Mailing list pgsql-general

From Jasen Betts
Subject Re: combining db's- importing primary keys
Date
Msg-id h4ph8a$pi$2@reversiblemaps.ath.cx
Whole thread Raw
In response to combining db's- importing primary keys  (Bob Gobeille <bob.gobeille@hp.com>)
Responses Re: combining db's- importing primary keys
Re: combining db's- importing primary keys
List pgsql-general
Tree view 
On 2009-07-27, Bob Gobeille <bob.gobeille@hp.com> wrote:
> I would like to combine multiple databases (same schema) into one
> master db.   Does anyone know how I can reconcile all my primary and
> foreign keys to maintain referential integrity.

prefix them all with something that's unique to their source database.

easy to say, hard to do.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Clients disconnect but query still runs
Next
From: mzhang@ilww.com
Date:
Subject: org.postgresql.util.PSQLException: PANIC: could not write to log file