sharing data accross several databases - Mailing list pgsql-sql

From bob lapique
Subject sharing data accross several databases
Date
Msg-id GQCBOL$Ian3fEvZaErv5KfFYVf_mG14AhHTzzHRycHQ8jPZa0N@tiscali.fr
Whole thread Raw
Responses Re: sharing data accross several databases
List pgsql-sql
Hi,

I am designing 2 databases :
- the 1st relates to flasks
- the 2nd relates to cylinders

Both flasks and cylinders will be shipped accross the 
world and I need to keep track of check out dates, 
shipping method, destination, etc. These data will be of 
the same type for both databases.

Questions :
-----------
1) Is a 3rd database the solution ?
2) I would like to keep on using foreign keys (e.g. 
between a shipped item and the destination location)

Thanks for help.

-------------------
Vous aussi devenez le "Coup de coeur de Julie" et gagnez une Webcam
sur http://www.chez.com !
Chez.com vous invite � d�couvrir l'univers passionnant des sites persos.




pgsql-sql by date:

Previous
From: David Stanaway
Date:
Subject: Re: Passing a list of pairs to a PL/PGSQL function
Next
From: "Urs Steiner"
Date:
Subject: Re: list triggers ?