pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / 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>
  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-12 02:23  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Siddharth Jain <siddhsql@gmail.com>
  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