Re: [GENERAL] rollback question... - Mailing list pgsql-general

From A James Lewis
Subject Re: [GENERAL] rollback question...
Date
Msg-id Pine.LNX.3.93.981111165227.17616C-100000@vr1-workhorse1.vrtx.net
Whole thread Raw
In response to Re: [GENERAL] rollback question...  (David Hartwig <daveh@insightdist.com>)
List 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?


pgsql-general by date:

Previous
From: David Hartwig
Date:
Subject: Re: [GENERAL] rollback question...
Next
From: "Gene Selkov Jr."
Date:
Subject: Re: [INTERFACES] need information about storing methods