One transaction and several processes - Mailing list pgsql-general

From Valery Kuzmin
Subject One transaction and several processes
Date
Msg-id CAHRx4ijKggM=gEbZjgM3WojVEnuQnhSPS-0sdCo9MtNOq_Sgpg@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi,

Can multiple processes participate in a single transaction's execution?
I need to do the following actions sequence:
1. Calling service begins transaction. At this step transaction
manager generate new XID.
2. Calling service updates some data.
3. Need to detach a transaction from a service context before other
service is called.
4. Called service resume transaction using XID.
5. Called service updates its data.
6. Calling service gets control, resume transaction using XID and does commit.
How can the third and fourth step be implemented?

Best regards,
Valery


pgsql-general by date:

Previous
From: "Enrico Thierbach"
Date:
Subject: Re: Trouble matching a nested value in JSONB entries
Next
From: Laurenz Albe
Date:
Subject: Re: Analyze plan of foreign data wrapper