| From: | Valery Kuzmin <valerij(dot)kuzmin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | One transaction and several processes |
| Date: | 2018-07-03 10:28:26 |
| Message-ID: | CAHRx4ijKggM=gEbZjgM3WojVEnuQnhSPS-0sdCo9MtNOq_Sgpg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2018-07-03 10:38:07 | Re: Analyze plan of foreign data wrapper |
| Previous Message | Enrico Thierbach | 2018-07-03 10:16:46 | Re: Trouble matching a nested value in JSONB entries |