One transaction and several processes

From: Valery Kuzmin <valerij(dot)kuzmin(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: One transaction and several processes
Date: 2018-07-18 15:31:07
Message-ID: CAHRx4ih4+TbJDhH_XiDdFvsF2h+J7Xhu-ssV1tVu+m_qfz+P9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2018-07-18 15:40:19 Re: One transaction and several processes
Previous Message Tomas Vondra 2018-07-18 15:27:40 Re: [HACKERS] logical decoding of two-phase transactions