Re: Foreign key from another database - Mailing list pgsql-sql

From Joe Conway
Subject Re: Foreign key from another database
Date
Msg-id 3E8C76DD.3030306@joeconway.com
Whole thread Raw
In response to Foreign key from another database  (antti.ijas@arcada.fi (Antti Ijäs))
List pgsql-sql
Antti Ijäs wrote:
> Can I have a reference (with cascading), to another database? Let me
> try to explain the situation a little better ;-)
>

You can write a trigger that uses functions from contrib/dblink to
execute a command in another database. However, without two-phase commit
support I don't think you can be sure the entire operation is atomic.

Joe



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: pesky plpgsql
Next
From: Victor Yegorov
Date:
Subject: Re: auto-commit