Re: Rollback deletes

From: "Oleg Lebedev" <oleg(dot)lebedev(at)waterford(dot)org>
To: "Doug McNaught" <doug(at)wireboard(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rollback deletes
Date: 2002-10-23 18:55:28
Message-ID: 993DBE5B4D02194382EC8DF8554A5273016E0D@postoffice.waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

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

"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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-10-23 18:57:52 Re: Rollback deletes
Previous Message Doug McNaught 2002-10-23 18:43:37 Re: Rollback deletes