Re: Commit turns into rollback?

Ü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