Re: [ADMIN] Delete accident

2003-10-03 Thread Anna Kanevsky 
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

Re: [ADMIN] Delete accident

2003-10-02 Thread Gaetano Mendola 
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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Delete accident

2003-10-02 Thread Stephan Szabo 
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.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]