Postgres Pro
Downloads
Home   >   mailing lists

Re: Does Postgres rollback transactions on all errors? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Does Postgres rollback transactions on all errors?
Date
Msg-id 6570.987976602@sss.pgh.pa.us
Whole thread Raw
In response to Does Postgres rollback transactions on all errors?  (Ryan Ho <ryanho@cyberronins.com>)
List pgsql-novice
Tree view 
Ryan Ho <ryanho@cyberronins.com> writes:
> In a transaction, should any of the sql statements fail to execute, does Postgres rollback all the previous
statements?

Yes.

> To my best knowledge, it should but I have observed that on some occasions, half my transaction can get committed,
whilethe other half is unsuccessful. 

Hard to believe.  Can you provide some evidence?

            regards, tom lane

pgsql-novice by date:

Previous
From: Steve Waldman
Date:
Subject: Re: BLOB Type ?
Next
From: "Eric Naujock "
Date:
Subject: Re: Does Postgres rollback transactions on all errors?