Thread: rollback question...
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
> > 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
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
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?