Обсуждение: Rollback deletes

"Oleg Lebedev" <oleg.lebedev@waterford.org> writes:

> Can anybody point me to docs explaining how to rollback recent
> transactions.
> Is it possible to rollback recent deletions only?
> Can I specify the point in time to which I want to rollback?

Currently, you can roll back a transaction that is open (not
committed) using the ROLLBACK statement.  Once you COMMIT, you can't
"undo" a transaction (unless you wipe out the database and restore
from a backup, or manually reverse all the changes you made).

-Doug

Isn't there a way to use WAL files to do this?


-----Original Message-----
From: Doug McNaught [mailto:doug@wireboard.com]
Sent: Wednesday, October 23, 2002 12:44 PM
To: Oleg Lebedev
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Rollback deletes


"Oleg Lebedev" <oleg.lebedev@waterford.org> writes:

> Can anybody point me to docs explaining how to rollback recent
> transactions. Is it possible to rollback recent deletions only?
> Can I specify the point in time to which I want to rollback?

Currently, you can roll back a transaction that is open (not
committed) using the ROLLBACK statement.  Once you COMMIT, you can't
"undo" a transaction (unless you wipe out the database and restore from
a backup, or manually reverse all the changes you made).

-Doug

"Oleg Lebedev" <oleg.lebedev@waterford.org> writes:

> Isn't there a way to use WAL files to do this?

No.

There has been discussion about savepoints and nested transactions
(which is close to what you're talking about) but they are not in
current versions or in the 7.3 beta.

-Doug