Re: How should I end a transaction with possibly failed queries? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How should I end a transaction with possibly failed queries?
Date
Msg-id 28187.1251921691@sss.pgh.pa.us
Whole thread Raw
In response to How should I end a transaction with possibly failed queries?  (Sergey Samokhin <prikrutil@gmail.com>)
Responses Re: How should I end a transaction with possibly failed queries?
List pgsql-novice
Sergey Samokhin <prikrutil@gmail.com> writes:
> Does it seem right to send "COMMIT" without checking whether any of
> the queries I've done in the transaction failed?

If anything failed, COMMIT is interpreted as ROLLBACK anyway.

Some other DBMSes might do this differently, but that's what PG does.

            regards, tom lane

pgsql-novice by date:

Previous
From: Ruzsinszky Attila
Date:
Subject: Re: Modifying selected records
Next
From: Sergey Samokhin
Date:
Subject: Re: How should I end a transaction with possibly failed queries?