From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(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 17:51:49 |
Message-ID: | Pine.LNX.4.33.0303061051360.5572-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2003-03-06 17:57:37 | Re: Sequence Of Dates ( Posting 2nd Time) |
Previous Message | Hunter Hillegas | 2003-03-06 17:49:43 | Info on Long Running Queries |