Re: Foreign key from another database

From: Joe Conway <mail(at)joeconway(dot)com>
To: Antti Ijäs <antti(dot)ijas(at)arcada(dot)fi>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Foreign key from another database
Date: 2003-04-03 18:01:01
Message-ID: 3E8C76DD.3030306@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-04-03 18:01:36 Re: pesky plpgsql
Previous Message Victor Yegorov 2003-04-03 17:34:39 Re: auto-commit