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