Re: [GENERAL] Implementing 2 different transactions in a PL/Perl function

2007-07-10 Thread Richard Huxton
Jasbinder Singh Bali wrote: You mean to say keep using spi_exec till I want everything in the same transaction and the point where I want a separate transaction, use DBI ? Yes - if you have two functions A,B then do everything as normal in each, except you call function B using dblink() from f

Re: [GENERAL] Implementing 2 different transactions in a PL/Perl function

2007-07-10 Thread Jasbinder Singh Bali
You mean to say keep using spi_exec till I want everything in the same transaction and the point where I want a separate transaction, use DBI ? On 7/10/07, Richard Huxton <[EMAIL PROTECTED]> wrote: Jasbinder Singh Bali wrote: > Hi, > > How can I have two different transactions is a plperlu func

Re: [GENERAL] Implementing 2 different transactions in a PL/Perl function

2007-07-10 Thread Michael Glaesemann
On Jul 10, 2007, at 14:41 , Jasbinder Singh Bali wrote: I basically want 2 independent transactions in my function so that 1 commits as soon as it is done and 2 doesn't depend on it at all. If they're truly independent, I'd write them as two separate functions., possibly calling both of t

Re: [GENERAL] Implementing 2 different transactions in a PL/Perl function

2007-07-10 Thread Richard Huxton
Jasbinder Singh Bali wrote: Hi, How can I have two different transactions is a plperlu function? My purpose is as follows:- Transaction 1 does some series of inserts in tbl_abc Transaction 2 updates some columns in tbl_abc fetching records from some other table. You'll have to connect back to

[GENERAL] Implementing 2 different transactions in a PL/Perl function

2007-07-10 Thread Jasbinder Singh Bali
Hi, How can I have two different transactions is a plperlu function? My purpose is as follows:- Transaction 1 does some series of inserts in tbl_abc Transaction 2 updates some columns in tbl_abc fetching records from some other table. I basically want 2 independent transactions in my function s