Re: foreign key constraint across databases

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Siva Kumar <siva(at)leatherlink(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: foreign key constraint across databases
Date: 2003-03-06 05:47:48
Message-ID: 20030305214651.T74875-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 6 Mar 2003, Siva Kumar wrote:

> Is it possible to have a column in Table-2 of Database-B to have a foreign key
> constraint referencing Table-1 of Database-A?

Not using the straight foreign key support (you might be able to put
something together using dblink in your own triggers, but it'd probably be
more trouble than it's worth)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-06 06:15:54 Re: My contract has been renewed
Previous Message Joe Conway 2003-03-06 05:32:01 Re: [HACKERS] problems with dropped columns