Re: Delete accident

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Delete accident
Дата
Msg-id 20031002164129.B76566@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Delete accident  (Anna Kanevsky <akanevsky@aahe.org>)
Список pgsql-admin
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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Chris White (cjwhite)"
Дата:
Сообщение: Re: Question about DB VACUUM
Следующее
От: Gaetano Mendola
Дата:
Сообщение: News group