Thread: Subtransactions in PostgreSQL

Subtransactions in PostgreSQL

From
Amine Tengilimoglu
Date:
Hello everyone;

        Is there any way to detect the main transaction of a subtransaction in postgres, or any tool that can read the files in pg_subtrans? 

PG version: 14.5

thank you.

Re: Subtransactions in PostgreSQL

From
Jeremy Schneider
Date:
On 1/3/23 10:10 AM, Amine Tengilimoglu wrote:
Is there any way to detect the main transaction of a subtransaction in postgres, or any tool that can read the files in pg_subtrans?

Would this extension help?

https://github.com/bdrouvot/pg_subtrans_infos


-- 
http://about.me/jeremy_schneider

Re: Subtransactions in PostgreSQL

From
Amine Tengilimoglu
Date:
Thanks a lot, I think this will work for me. 

Jeremy Schneider <schneider@ardentperf.com>, 3 Oca 2023 Sal, 22:06 tarihinde şunu yazdı:
On 1/3/23 10:10 AM, Amine Tengilimoglu wrote:
Is there any way to detect the main transaction of a subtransaction in postgres, or any tool that can read the files in pg_subtrans?

Would this extension help?

https://github.com/bdrouvot/pg_subtrans_infos


-- 
http://about.me/jeremy_schneider