Re: Does Postgres rollback transactions on all errors?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ryan Ho <ryanho(at)cyberronins(dot)com>
Cc: "<Postgres Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Does Postgres rollback transactions on all errors?
Date: 2001-04-22 21:56:42
Message-ID: 6570.987976602@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ryan Ho <ryanho(at)cyberronins(dot)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, while the other half is unsuccessful.

Hard to believe. Can you provide some evidence?

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Eric Naujock 2001-04-22 23:33:09 Re: Does Postgres rollback transactions on all errors?
Previous Message Steve Waldman 2001-04-22 21:19:50 Re: BLOB Type ?