Re: Rollback deletes

Doug McNaught <doug@wireboard.com>

From: Doug McNaught <doug@wireboard.com>
To: "Oleg Lebedev" <oleg.lebedev@waterford.org>
Cc: <pgsql-general@postgresql.org>
Date: 2002-10-23T18:43:37Z
Lists: 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