Thread: Delete accident

This is an almost embarrassing question, but I managed to delete all rows out of one of the tables by making a little typo in the WHERE statement.

Is there any way to restore these? the db was NOT vacuumed after that. but then, it wasn't backed up before either.
please help!
thanks.

____________________________________
Anya Kanevsky
Manager, Web Projects
American Association for Higher Education
One Dupont Circle, Suite 360
Washington, DC 20036-1143
202.293.6440 ext 786
www.aahe.org

Submit your proposal for the national 2004 Learning to Change Conference at http://www.aahe.org/learningtochange.
The proposal deadline is October 1.  The conference is April 1-4 in at the Sheraton San Diego Hotel & Marina.

Anna Kanevsky wrote:
> This is an almost embarrassing question, but I managed to delete all
> rows out of one of the tables by making a little typo in the WHERE
> statement.

When you do update or delete is good do it inside a transaction, I guess
you didn't !
I think that your datas are lost.

Gaetano

On Tue, 30 Sep 2003, Anna Kanevsky wrote:

> This is an almost embarrassing question, but I managed to delete all rows
> out of one of the tables by making a little typo in the WHERE statement.
> Is there any way to restore these? the db was NOT vacuumed after that. but
> then, it wasn't backed up before either.

Potentially, if vacuum wasn't run, you may be able to go back, find the
transaction that did the delete and mark it as having rolled back, but I
don't really know the details necessary to make that work.

Thank you everyone!
I got a load of responses, and don't want to keep anyone working at this.
the magic is in pgfsck! http://svana.org/kleptog/pgsql/pgfsck.html
-anya