what happens if a failed transaction is not rolled back? - Mailing list pgsql-general

From Siddharth Jain
Subject what happens if a failed transaction is not rolled back?
Date
Msg-id CAPqV3pQms8Z5-v7vxZ9pRMxf7n0wOW+XUZ9cWjBP5=Fu=4_NFA@mail.gmail.com
Whole thread Raw
Responses Re: what happens if a failed transaction is not rolled back?
Re: what happens if a failed transaction is not rolled back?
Re: what happens if a failed transaction is not rolled back?
List pgsql-general
Hi All,

i understand when writing application code, we should rollback a transaction that fails to commit. this is typically done in the catch block of a try-catch exception handler. but what if the developer does not rollback the transaction? what happens in that case? 

note that i am not asking: what happens if a transaction is not rolled back?
i am asking: what happens if a failed transaction is not rolled back?

failed transaction = you try to commit it but get an exception back from the database.

thanks.

S.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question
Next
From: Tom Lane
Date:
Subject: Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question