pg.ddx.io pgsql-general@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Transaction Rollback errors 2+ messages / 2 participants [nested] [flat]
* Transaction Rollback errors @ 2023-04-11 23:31 Siddharth Jain <siddhsql@gmail.com> 2023-04-12 02:23 ` Re: Transaction Rollback errors Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Siddharth Jain @ 2023-04-11 23:31 UTC (permalink / raw) To: pgsql-general@lists.postgresql.org 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_detectedthen does it mean PG has already rolled back the tx and therefore I should not attempt to roll it back again? Thanks, S. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Transaction Rollback errors 2023-04-11 23:31 Transaction Rollback errors Siddharth Jain <siddhsql@gmail.com> @ 2023-04-12 02:23 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-04-12 02:23 UTC (permalink / raw) To: Siddharth Jain <siddhsql@gmail.com>; +Cc: pgsql-general@lists.postgresql.org Siddharth Jain <siddhsql@gmail.com> writes: > 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_detectedthen does it mean PG has already rolled back the tx > and therefore I should not attempt to roll it back again? Thanks, No, treat these the same as any other error. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-04-12 02:23 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-04-11 23:31 Transaction Rollback errors Siddharth Jain <siddhsql@gmail.com> 2023-04-12 02:23 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox