Re: [GENERAL] rollback question...

A James Lewis <james@vrtx.net>

From: A James Lewis <james@vrtx.net>
To: David Hartwig <daveh@insightdist.com>
Cc: Lorenzo Huerta <lorhuerta@yahoo.com>, pgsql-general@postgreSQL.org
Date: 1998-11-11T16:54:42Z
Lists: pgsql-general
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?