sharing data accross several databases

From: "bob lapique"<lapique(at)chez(dot)com>
To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: sharing data accross several databases
Date: 2002-01-22 12:50:45
Message-ID: GQCBOL$Ian3fEvZaErv5KfFYVf_mG14AhHTzzHRycHQ8jPZa0N@tiscali.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 dcouvrir l'univers passionnant des sites persos.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Urs Steiner 2002-01-22 15:48:53 Re: list triggers ?
Previous Message David Stanaway 2002-01-22 04:05:45 Re: Passing a list of pairs to a PL/PGSQL function