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.

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:

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?

How large is the pool of information you are dealing with..... how much
granularity are you looking for?

I suppose you could put in a rule that copied the entire table on every
update.... then age out the copies after a while...

Mabe even do a bit of re-designing the structure if possible to accomodate
a date stamp on a record and allow dupliate records.. then select only the
latest one... then you could delete any change you liked....

On Thu, 12 Nov 1998, Lorenzo Huerta wrote:

but that will only happen for one single transaction correct, ie it
can only roll back at most one set of changes? See i am accessing my
postgres tables from php scripts and we wanted to find a way, if
possible, to go back in history and restore a certain record. Sounds
like the "rollback" function will only be able to restore the last
change commited in the database. So hmm i guess what i can do is to
either create an initial dumpfile and enter it into cvs, then
periodically store commit the changes i make into the cvs backed up one.

Any other suggestions to help with this problem?

---A James Lewis <james@vrtx.net> wrote:

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?

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