Re: Foreign Key between different databases

AFAIK, not easily.  There was a post to the hackers list recently with
code for a "database connector" function.  Using this it may be possible
to write your own referential integrity triggers that reference the other
database.. maybe not.  I didn't look much into the code.  There might be
something else around somewhere.  Note that in order to enforce "full" RI
you will have to write these functions in both databases.  Oh, and the
other database does have to be a Postgresql database with the above
mentioned code.

-Cedar

On Tue, 10 Apr 2001, Stan van de Mortel wrote:

> Hello,
> 
> I've a table in a database and I want to create a column that is a foreign
> key to a table in an other database. When I try ...,foreign key (x)
> references otherdb.table(x) it says 'parse error at or near "."'.
> 
> Is there an other way to create this kind of foreign key?
> 
> Stan van de Mortel
> [SvdMortel@InterPlein.nl]
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>