Re: A generic trigger to log chanes on database tables

Поиск
Список
Период
Сортировка
От George Weaver
Тема Re: A generic trigger to log chanes on database tables
Дата
Msg-id 003e01c712d7$9200e7f0$6400a8c0@Dell4500
обсуждение исходный текст
Ответ на A generic trigger to log chanes on database tables  ("Charles Ambrose" <jamjam360@gmail.com>)
Список pgsql-general
----- Original Message -----
From: "Charles Ambrose" <jamjam360@gmail.com>

> Is there a way that I could create a trigger that logs the changes
> (updates, deletes) of a table? I mean, I want to put in a table the
> changes to any table in a database and also put in the table the  column
> that was modified and the corresponding value.

Charles,

You may want to check out the following (may also give you addtional ideas
for what you're trying to achieve):

http://www.varlena.com/GeneralBits/104.php
(Logging Audit Changes with Composite Typed Columns).

Regards,
George



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

Предыдущее
От: Ragnar
Дата:
Сообщение: Re: sequence help
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Question about encoding