pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to undelete deleted data
2+ messages / 2 participants
[nested] [flat]
* How to undelete deleted data
@ 2003-05-29 09:37 Abdul Wahab Dahalan <wahab@mimos.my>
0 siblings, 1 reply; 2+ messages in thread
From: Abdul Wahab Dahalan @ 2003-05-29 09:37 UTC (permalink / raw)
To: pgsql-sql
How can I undelete the deleted data from a table;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to undelete deleted data
@ 2003-05-29 11:21 Bruno Wolff III <bruno@wolff.to>
parent: Abdul Wahab Dahalan <wahab@mimos.my>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2003-05-29 11:21 UTC (permalink / raw)
To: Abdul Wahab Dahalan <wahab@mimos.my>; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-05-29 11:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-29 09:37 How to undelete deleted data Abdul Wahab Dahalan <wahab@mimos.my>
2003-05-29 11:21 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox