Re: How should I end a transaction with possibly failed queries?

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