Postgres Pro
Downloads
Home   >   mailing lists

Implementing 2 different transactions in a PL/Perl function - Mailing list pgsql-general

From Jasbinder Singh Bali
Subject Implementing 2 different transactions in a PL/Perl function
Date
Msg-id a47902760707101241t2fe557b3q17b927ffa37a0bb4@mail.gmail.com
Whole thread Raw
Responses Re: Implementing 2 different transactions in a PL/Perl function
Re: Implementing 2 different transactions in a PL/Perl function
List pgsql-general
Tree view
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 so that 1 commits as soon as it is done and 2 doesn't
depend on it at all.

Thanks,
~Jas

pgsql-general by date:

Previous
From: AlJeux
Date:
Subject: Re: vacuumdb: PANIC: corrupted item pointer
Next
From: Ben
Date:
Subject: Am I missing something about the output of pg_stop_backup()?