Title: RE: [ADMIN] Delete accident
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
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