Re: Option to undo last update on table.

Поиск
Список
Период
Сортировка
От RPK
Тема Re: Option to undo last update on table.
Дата
Msg-id 8990995.post@talk.nabble.com
обсуждение исходный текст
Ответ на Re: Option to undo last update on table.  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Option to undo last update on table.  (Alan Hodgson <ahodgson@simkin.ca>)
Список 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.


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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Protect PL/PGSQL source
Следующее
От: Emi Lu
Дата:
Сообщение: Re: postgresql 8.2 Installation error at "gmake"