Re: Commit turns into rollback?

Ühel kenal päeval, R, 2006-03-17 kell 11:27, kirjutas Peter Eisentraut:
> Am Freitag, 17. März 2006 11:25 schrieb Hannu Krosing:
> > > => commit;
> > > ROLLBACK
> > > ^^^^^^^^
> >
> > Return status tells you what actually happened.
>
> If I send a COMMIT, I want a commit to happen or an error.

You already got several errors.

Any suggestion how to get out of the ERROR state ?

=> begin;
BEGIN
=> blah;
ERROR: ...
=> commit;
ERROR: ...
=> select 1;
ERROR: current transaction is aborted, commands ignored until end of
transaction block

Or would you like a mode where you need explicitly send a ROLLBACK to
get out ?

> > > Even if this is justifiable, this behavior is not documented (in any
> > > obvious place).
> >
> > What would you suggest as an obvious place ?
>
> The COMMIT reference page would be a start.

Good point :)

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