Re: [HACKERS] transaction rollbacks on error

Peter Garner wrote:
>
> Hi all
>
> I hope no one finds this the wrong Mailing List, but I would like to
> request/propose a change in PostGres. (I may even hack this one in
> myself if no one objects.)
>
> It seems that ANY error in postgres voids the entire transaction. I.e.
> if an error occurs, one must immediately commit decide to commit or
> rollback the current transaction. No further updates will be accepted
> until this is done. I am almost postive that most commercial databases
> do not behave this way. (I do not think that DB2 does, but I have had
> very little to do with other databases since discovering Postgresql! ;-)
> At the VERY least it would be nice to have a user option whereby errors
> would not affect the current transaction state.

I'm going to implement savepoints (and _implicit_ savepoints)
in 6.6.

Vadim