Re: Adding ddl audit trigger

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Adding ddl audit trigger
Дата
Msg-id 4D40A314.2070502@lelarge.info
обсуждение исходный текст
Ответ на Re: Adding ddl audit trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Adding ddl audit trigger
Список pgsql-general
Le 26/01/2011 23:13, Tom Lane a écrit :
> Guillaume Lelarge <guillaume@lelarge.info> writes:
>> Le 26/01/2011 22:29, Lawrence Cohan a écrit :
>>> All I need is to at least be able and save a userid(current_user), timestamp, action, and the name of the object
andthis could be done easily by adding triggers to these pg catalogs. 
>
>> Nope, sorry. You can't add triggers on system catalogs.
>
> This has been discussed, and I think it's on the TODO list.  It's not
> "easily done".
>

Yes, AFAIR, it was discussed during pgcon dev meeting last year. Jan
Wieck was interested to work on this (I suppose to help Slony work
better with DDL). Still hope to see some progress on this :)


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

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

Предыдущее
От: Dan Birken
Дата:
Сообщение: Re: Understanding PG9.0 streaming replication feature
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Understanding PG9.0 streaming replication feature