sharing data accross several databases

Поиск
Список
Период
Сортировка
От bob lapique
Тема sharing data accross several databases
Дата
Msg-id GQCBOL$Ian3fEvZaErv5KfFYVf_mG14AhHTzzHRycHQ8jPZa0N@tiscali.fr
обсуждение исходный текст
Ответы Re: sharing data accross several databases  ("Josh Berkus" <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: David Stanaway
Дата:
Сообщение: Re: Passing a list of pairs to a PL/PGSQL function
Следующее
От: "Urs Steiner"
Дата:
Сообщение: Re: list triggers ?