Re: Rollback deletes

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