Postgres Pro
Downloads
Home   >   mailing lists

Re: referring to a different database from a trigger - Mailing list pgsql-general

From Scott Marlowe
Subject Re: referring to a different database from a trigger
Date
Msg-id dcc563d10811211446o2a96bdd3yd303bb9cd5a1c0ec@mail.gmail.com
Whole thread Raw
In response to Re: referring to a different database from a trigger  (ries van Twisk <pg@rvt.dds.nl>)
Responses Re: referring to a different database from a trigger  (pw <p.willis@telus.net>)
List pgsql-general
Tree view 
On Fri, Nov 21, 2008 at 3:31 PM, ries van Twisk <pg@rvt.dds.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.

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Password and Installation
Next
From: pw
Date:
Subject: Re: referring to a different database from a trigger