Transaction Rollback errors

From: Siddharth Jain <siddhsql(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Transaction Rollback errors
Date: 2023-04-11 23:31:25
Message-ID: CAPqV3pT0RrxLSxtzo62fZ-TXpm7Uj63Ve4AxGg7+emNz7wWmbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_detectedthen does it mean PG has already rolled back the tx
and therefore I should not attempt to roll it back again? Thanks,

S.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Saydakov 2023-04-12 00:34:26 parallel aggregation
Previous Message Mike Bayer 2023-04-11 23:05:10 Re: Guidance on INSERT RETURNING order