Re: Undo an update - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: Undo an update
Date
Msg-id a55915760608160828k178af4bdha0db9d6862499eeb@mail.gmail.com
Whole thread Raw
In response to Re: Undo an update  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-sql
On 8/16/06, Markus Schaber <schabi@logix-tt.com> 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 something?

That's a type of audit trail.

It's useful when you what to see what changed, when, and who did it,
and let's you revert if necessary, without doing PITR.

So, yeah, it's useful.

Regards,

Rodrigo


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using bitmap index scans-more efficient
Next
From: "Jon Horsman"
Date:
Subject: DB creation script questions