Delete accident

From: Anna Kanevsky <akanevsky(at)aahe(dot)org>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Delete accident
Date: 2003-09-30 15:28:33
Message-ID: 29E95A5D2F22D511862E00508BC2183BBF1F44@aahebdc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-09-30 19:20:06 large type table
Previous Message Tom Lane 2003-09-30 15:08:56 Re: How can I make PosgreSQL use an Index ?