[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] How to undelete deleted data
From: Bruno Wolff III <bruno () wolff ! to>
Date: 2003-05-29 11:21:59
[Download RAW message or body]
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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic