Re: Rollback deletes - Mailing list pgsql-general

From Doug McNaught
Subject Re: Rollback deletes
Date
Msg-id m3hefdngh2.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Rollback deletes  ("Oleg Lebedev" <oleg.lebedev@waterford.org>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: SELECT statements converted to SELECT FOR UPDATE
Next
From: "Oleg Lebedev"
Date:
Subject: Re: Rollback deletes