Re: Delete accident - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Delete accident
Date
Msg-id 3F7CB648.7000006@bigfoot.com
Whole thread Raw
In response to Delete accident  (Anna Kanevsky <akanevsky@aahe.org>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about DB VACUUM
Next
From: "Chris White (cjwhite)"
Date:
Subject: Re: Question about DB VACUUM