Re: Undo an update

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Undo an update
Date: 2006-08-16 15:28:27
Message-ID: a55915760608160828k178af4bdha0db9d6862499eeb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 8/16/06, Markus Schaber <schabi(at)logix-tt(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jesper K. Pedersen 2006-08-16 16:12:06 OT: OpenDatabase Model ?
Previous Message Andrew Sullivan 2006-08-16 14:17:35 Re: problem with sequence.....