Re: Commit turns into rollback? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Commit turns into rollback?
Date
Msg-id 1142601776.3819.7.camel@localhost.localdomain
Whole thread Raw
In response to Re: Commit turns into rollback?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Ühel kenal päeval, R, 2006-03-17 kell 14:10, kirjutas Peter Eisentraut:
> Am Freitag, 17. März 2006 13:03 schrieb Hannu Krosing:
> > > If I send a COMMIT, I want a commit to happen or an error.
> >
> > You already got several errors.
> 
> Right, but a defensively programmed application, I want to get all the errors 
> all the time at every possible place.
> 
> > Or would you like a mode where you need explicitly send a ROLLBACK to
> > get out ?
> 
> I faintly recall that this used to be the behavior.

in 7.4 it was worse 

ahf=# begin;
BEGIN
ahf=# select 1/0;
ERROR:  division by zero
ahf=# commit;
COMMIT

it still did a rollback, but reported a COMMIT

-----------
Hannu




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Commit turns into rollback?
Next
From: Tom Lane
Date:
Subject: Re: Automatically setting work_mem