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

From Adrian Klaver
Subject Re: Query on Postgres SQL transaction
Date
Msg-id 48ea6606-41ad-4094-887a-466c8c827bf2@aklaver.com
Whole thread Raw
In response to Query on Postgres SQL transaction  ("Bandi, Venkataramana - Dell Team" <Venkataramana.Bandi@dellteam.com>)
List pgsql-general


On 3/14/24 11:04 PM, Bandi, Venkataramana - Dell Team wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:DengXian; panose-1:2 1 6 0 3 1 1 1 1 1;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:"\@DengXian"; panose-1:2 1 6 0 3 1 1 1 1 1;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ligatures:standardcontextual;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif;}div.WordSection1 {page:WordSection1;}

Hi Team,

 

We are using JPA entities to persists the records into Postgres SQL DB and its working for all the nodes but one of the node data is not persisting and it’s not giving any DB related errors/exception. We just want to trace out this scenario on transaction level whether transaction is committing or not.


"... its working for all the nodes but one of the node data is not persisting ..." contradict.

Generally when a record does not throw an error, but is not persisted it means the transaction was not committed and the changes did not survive the session they where done in. Without the actual code it hard to say anything more.

 

Could you please let us know how we can trace out this scenario and let us know how transaction logs enabled in Postgres SQL DB.

 

 

Regards,

Venkat

 


Internal Use - Confidential

-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostGres ODBC too slow
Next
From: vedant patel
Date:
Subject: Re: PostGres ODBC too slow