On 8/16/06, Markus Schaber <[EMAIL PROTECTED]> wrote:
Hi, Kis,
Kis János Tamás wrote:
> So, if you send every insert, update, delete command to a
> logger-table, then you can to undo anything.
But this is just re-inventing the wheel, we already have Point-in-Time
recovery.
Or do I miss someth
Hi, Kis,
Kis János Tamás wrote:
> So, if you send every insert, update, delete command to a
> logger-table, then you can to undo anything.
But this is just re-inventing the wheel, we already have Point-in-Time
recovery.
Or do I miss something?
Markus
--
Markus Schaber | Logical Tracking&T
2006. August 11. Friday 19.26 dátummal Judith ezt írta:
>
> Is there a way to undo an update???
>
At the 1st time: I speak little english, so I sorry.
If I understand, what's your problem, maybe I can help you... Maybe...
So, if I'd like to save the inserted, deleted and/or updated rows,
then
Hi, Judith,
Judith wrote:
>Is there a way to undo an update???
I'm sorry, but his is one of those short questions that only have long,
complex answers.
If this answer is to long / complicated for you, begin from the top, and
whenever it get's worse, ask yourself how urgent your problem is,
If it was inside a transaction, and the transaction is still open,
then just rollback.
Otherwise, no.
I'm not sure if there's any way of doing some kind of PITR, no familiar with it.
If not, best bet is to recover from the newest backup set you have.
Regards,
Rodrigo
Hello everybody!!
Is there a way to undo an update???
Thanks!!!
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
