[GENERAL] referring to a different database from a trigger

2008-11-21 Thread pw
Hello, Is there a syntax for querying another database from a trigger in the current database? Thanks for any info, P -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] referring to a different database from a trigger

2008-11-21 Thread ries van Twisk
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, P Generally we would say DBLink or DBI-Link Ries -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] referring to a different database from a trigger

2008-11-21 Thread Scott Marlowe
On Fri, Nov 21, 2008 at 3:31 PM, ries van Twisk [EMAIL PROTECTED] 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

Re: [GENERAL] referring to a different database from a trigger

2008-11-21 Thread pw
Scott Marlowe wrote: On Fri, Nov 21, 2008 at 3:31 PM, ries van Twisk [EMAIL PROTECTED] wrote: Note that there are no built in transactional symantics in such situations. You got to roll your own. And they may not work. Yeah, that was what I was hoping for. ie:(query between databases)

Re: [GENERAL] referring to a different database from a trigger

2008-11-21 Thread Scott Marlowe
On Fri, Nov 21, 2008 at 4:43 PM, pw [EMAIL PROTECTED] wrote: Scott Marlowe wrote: On Fri, Nov 21, 2008 at 3:31 PM, ries van Twisk [EMAIL PROTECTED] wrote: Note that there are no built in transactional symantics in such situations. You got to roll your own. And they may not work. Yeah,

Re: [GENERAL] referring to a different database from a trigger

2008-11-21 Thread pwillis
Scott Marlowe wrote: On Fri, Nov 21, 2008 at 4:43 PM, pw [EMAIL PROTECTED] wrote: Scott Marlowe wrote: On Fri, Nov 21, 2008 at 3:31 PM, ries van Twisk [EMAIL PROTECTED] wrote: Note that there are no built in transactional symantics in such situations. You got to roll your own. And they may