Re: referring to a different database from a trigger

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "ries van Twisk" <pg(at)rvt(dot)dds(dot)nl>
Cc: pw <p(dot)willis(at)telus(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: referring to a different database from a trigger
Date: 2008-11-21 22:46:22
Message-ID: dcc563d10811211446o2a96bdd3yd303bb9cd5a1c0ec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 21, 2008 at 3:31 PM, ries van Twisk <pg(at)rvt(dot)dds(dot)nl> wrote:
>
> On Nov 21, 2008, at 5:26 PM, pw wrote:
>
>> Hello,
>>
>> Is there a syntax for querying another database
>> from a trigger in the current database?
>>
>> Thanks for any info,
>
> Generally we would say DBLink or DBI-Link

Note that there are no built in transactional symantics in such
situations. You got to roll your own. And they may not work.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pw 2008-11-21 23:43:07 Re: referring to a different database from a trigger
Previous Message Dave Page 2008-11-21 22:35:33 Re: Password and Installation