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 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 yourself using dblink() or dbilink() - see contrib/ for details. Don't forget to consider what it means to have a connection string in a function-body either. -- Richard Huxton Archonet Ltd
