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

From Stephan Szabo
Subject Re: Foreign Key relationship between two databases
Date
Msg-id 20050127053355.W68725@megazone.bigpanda.com
Whole thread Raw
In response to Foreign Key relationship between two databases  ("Sandeep Gaikwad" <sgaikwad@vertex.co.in>)
List pgsql-sql
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.

pgsql-sql by date:

Previous
From: "Sandeep Gaikwad"
Date:
Subject: Foreign Key relationship between two databases
Next
From: Sean Davis
Date:
Subject: Re: What's the equivalent in PL/pgSQL