Re: Undo an update

Поиск
Список
Период
Сортировка
От Rodrigo De León
Тема Re: Undo an update
Дата
Msg-id a55915760608160828k178af4bdha0db9d6862499eeb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Undo an update  (Markus Schaber <schabi@logix-tt.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using bitmap index scans-more efficient
Следующее
От: "Jon Horsman"
Дата:
Сообщение: DB creation script questions