Re: [SQL] implementing an out-of-transaction trigger

2004-09-15 Thread Iain
name of the notification to determine what processing to activate. Thanks, Iain - Original Message - From: "Greg Stark" <[EMAIL PROTECTED]> To: "Iain" <[EMAIL PROTECTED]> Cc: "Mike Rylander" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sen

Re: [SQL] implementing an out-of-transaction trigger

2004-09-15 Thread Greg Stark
"Iain" <[EMAIL PROTECTED]> writes: > Though, as far as I can tell, there is no way to have the notify activate a > pl/pgsql function directly. I'll still need to write a client program to > create a session and actually do the listening, that is if I havn't missed > anything else... Right, presu

Re: [SQL] implementing an out-of-transaction trigger

2004-09-15 Thread Iain
ECTED]> Sent: Thursday, September 16, 2004 1:03 AM Subject: Re: [SQL] implementing an out-of-transaction trigger > >I've come across a situation where I'd like to use some kind of > "out-of-transaction > >trigger" to do some processing after changes to some

Re: [SQL] implementing an out-of-transaction trigger

2004-09-15 Thread Mike Rylander
>I've come across a situation where I'd like to use some kind of "out-of-transaction >trigger" to do some processing after changes to some tables, but without extending >the duration of the main transaction. Of course, it's important that the processing be >completed so it has to be, as far as poss