Обсуждение: How to undelete deleted data

Поиск
Список
Период
Сортировка

How to undelete deleted data

От
Abdul Wahab Dahalan
Дата:
How can I undelete the deleted data from a table;



Re: How to undelete deleted data

От
Bruno Wolff III
Дата:
On Thu, May 29, 2003 at 17:37:19 +0800, Abdul Wahab Dahalan <wahab@mimos.my> wrote:
> How can I undelete the deleted data from a table;

If you notice before you commit, you issue a rollback. Otherwise you need
to recover from backup. If you don't have a backup, then you might be
able to do some fancy stuff to see old tuples. If you are going to do
this you should shutdown the database and make a copy of what you have.
If you haven't done a vacuum since the delete, the old tuples should
still be stored in the database.