I think there is confusion here....
every statement between the "begin work;" and the "rollback;" are rolled
back... not just one....
If you have not defined where to begin, you cannot roll back... it's not a
case of being able to back out individual commands one by one....
On Wed, 11 Nov 1998, David Hartwig wrote:
> Only the current transaction can be rolled back.
>
> Lorenzo Huerta wrote:
>
> > how many levels of rollbacks can postgres handle? Is it set to only
> > rollback changes for the last transaction done on a database, or can
> > you specify how many transactions to rollback to.
> >
> > lorenzo
> >
> > _________________________________________________________
> > DO YOU YAHOO!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
>
>
James (james@linuxrocks.co.uk)
Vortex Internet
My Windows unders~1 long filena~1, and yours?