Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign Key relationship between two databases - Mailing list pgsql-general

From Dawid Kuroczko
Subject Re: Foreign Key relationship between two databases
Date
Msg-id 758d5e7f050127060446c4bdb5@mail.gmail.com
Whole thread Raw
In response to Foreign Key relationship between two databases  ("Sandeep Gaikwad" <sgaikwad@vertex.co.in>)
List pgsql-general
Tree view 
On Thu, 27 Jan 2005 18:47:44 +0530, Sandeep Gaikwad
<sgaikwad@vertex.co.in> wrote:
> Hi,
>         I am using postgres 7.3.4. I am new to postgres.
>         I can give foreign key relationship between two tables of same database. Can I give foreign key relationship
betweentables of two databases ? Plz, let me know if possible & send me how can I do that? 

Well... what you can do is replicate such table between two pg databases
using Slony-I and then use foreign key on this replicated table.

  Regards,
       Dawid

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: An interesting pgpool benchmark result
Next
From: "David Beavan"
Date:
Subject: tsearch2 document and word limit