Re: Delete accident

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: Anna Kanevsky <akanevsky(at)aahe(dot)org>
Subject: Re: Delete accident
Date: 2003-10-02 23:35:36
Message-ID: 3F7CB648.7000006@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris White (cjwhite) 2003-10-02 23:40:08 Re: Question about DB VACUUM
Previous Message Tom Lane 2003-10-02 22:45:41 Re: Question about DB VACUUM