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.