Re: Option to undo last update on table.

From: RPK <rohitprakash123(at)indiatimes(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Option to undo last update on table.
Date: 2007-02-15 18:30:09
Message-ID: 8990995.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


In my case, I did an accidental update on a large table where different
column values have changed. I continued working and found next day that
something wrong happened.

Rollback will just rollback to last step (if I am right), but is there a way
to bring the table to a certain TimeStamp.

Just in case you have not heard of "FlashBack" facility in Oracle, check
this link:
http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
Oracle FlashBack Technology

I think PGSQL future versions must have something like this.

--
View this message in context: http://www.nabble.com/Option-to-undo-last-update-on-table.-tf3232456.html#a8990995
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-02-15 18:32:36 Re: Stored Procedure examples
Previous Message Merlin Moncure 2007-02-15 18:28:55 Re: Protect PL/PGSQL source