Foreign Key relationship between two databases

On Thu, 27 Jan 2005, Sandeep Gaikwad wrote:

I can give foreign key relationship between two tables of same
database. Can I give foreign key relationship between tables of two
databases ? Plz, let me know if possible & send me how can I do that?

Unfortunately, that's not really currently possible. You might be able to
fake some portion of it with custom triggers using dblink but I don't
think the locking would entirely work.

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 between tables 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