Re: foreign key constraint across databases - Mailing list pgsql-general

From scott.marlowe
Subject Re: foreign key constraint across databases
Date
Msg-id Pine.LNX.4.33.0303061051360.5572-100000@css120.ihs.com
Whole thread Raw
In response to Re: foreign key constraint across databases  (Siva Kumar <siva@leatherlink.net>)
List pgsql-general
On Thu, 6 Mar 2003, Siva Kumar wrote:

> On Thursday 06 March 2003 11:17 am, Stephan Szabo wrote:
> > 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)
>
> That is disappointing. We really do need this feature for our application. I
> heard that Oracle, MS SQL Server etc support this. What can we do to
> implement this in Postgresql also? Where should we look for? and what skill
> set is needed to extend Postgresql capabilities?
>
> Sorry for asking such basic question in the list. We are a small company and
> would like to contribute, but require a little hand-holding in the beginning

Might schemas provide the utility you're looking for?


pgsql-general by date:

Previous
From: Hunter Hillegas
Date:
Subject: Info on Long Running Queries
Next
From: Jean-Luc Lachance
Date:
Subject: Re: Sequence Of Dates ( Posting 2nd Time)