Thread: rollback question...

rollback question...

From
Lorenzo Huerta
Date:
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


Re: [GENERAL] rollback question...

From
Bruce Momjian
Date:
>
> 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.
>

Just the current transaction.  Never heard of multiple rollbacks.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: [GENERAL] rollback question...

From
David Hartwig
Date:
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


Re: [GENERAL] rollback question...

From
A James Lewis
Date:
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?