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