| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "Oleg Lebedev" <oleg(dot)lebedev(at)waterford(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Rollback deletes |
| Date: | 2002-10-23 18:43:37 |
| Message-ID: | m3hefdngh2.fsf@varsoon.wireboard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Oleg Lebedev" <oleg(dot)lebedev(at)waterford(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Lebedev | 2002-10-23 18:55:28 | Re: Rollback deletes |
| Previous Message | Stephan Szabo | 2002-10-23 18:37:43 | Re: SELECT statements converted to SELECT FOR UPDATE |