Home > mailing lists

Transaction Rollback errors - Mailing list pgsql-general

From	Siddharth Jain
Subject	Transaction Rollback errors
Date	April 12, 2023 02:31:25
Msg-id	CAPqV3pT0RrxLSxtzo62fZ-TXpm7Uj63Ve4AxGg7+emNz7wWmbw@mail.gmail.com Whole thread Raw
Responses	Re: Transaction Rollback errors
List	pgsql-general

Hi All,

when my application (Node.js) receives a class 40 error:

Class 40 — Transaction Rollback
`40000`	`transaction_rollback`
`40002`	`transaction_integrity_constraint_violation`
`40001`	`serialization_failure`
`40003`	`statement_completion_unknown`
`40P01`	`deadlock_detected`

then does it mean PG has already rolled back the tx and therefore I should not attempt to roll it back again? Thanks,

From: "Mike Bayer"
Date: 12 April 2023, 02:05:10
Subject: Re: Guidance on INSERT RETURNING order

From: Alexander Saydakov
Date: 12 April 2023, 03:34:26
Subject: parallel aggregation