Thread

1. rollback question...

   Lorenzo Huerta <lorhuerta@yahoo.com> — 1998-11-10T23:35:45Z

   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
   
   
   

2. Re: [GENERAL] rollback question...

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-11-11T11:21:18Z

   > 
   > 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
   
   

3. Re: [GENERAL] rollback question...

   David Hartwig <daveh@insightdist.com> — 1998-11-11T12:54:03Z

   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
   
   
   

4. Re: [GENERAL] rollback question...

   A James Lewis <james@vrtx.net> — 1998-11-11T16:54:42Z

   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?