Postgres Pro
Downloads
Home   >   mailing lists

Re: Query on Postgres SQL transaction - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Query on Postgres SQL transaction
Date
Msg-id CAKAnmmJvPT2ruoYL6OfJ+ygrpesK4FgVi2RyH9Z-iDeqYEdQgg@mail.gmail.com
Whole thread Raw
In response to Query on Postgres SQL transaction  ("Bandi, Venkataramana - Dell Team" <Venkataramana.Bandi@dellteam.com>)
List pgsql-general
Tree view
That log snippet shows two different PIDs. Check the logs to see the complete path that process 1876 took after it did the insert at  2024-02-19 15:21:54.850 +08

Make sure you are not using prepared transactions. This should return 0:

select current_setting('max_prepared_transactions');

Cheers,
Greg

pgsql-general by date:

Previous
From: "Bandi, Venkataramana - Dell Team"
Date:
Subject: RE: Query on Postgres SQL transaction
Next
From: Ron Johnson
Date:
Subject: Re: how to check if the license is expired.