Re: Adding ddl audit trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding ddl audit trigger
Date
Msg-id 26956.1296080018@sss.pgh.pa.us
Whole thread Raw
In response to Re: Adding ddl audit trigger  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Adding ddl audit trigger  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
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 and
thiscould 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".

            regards, tom lane

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Adding ddl audit trigger
Next
From: Dan Birken
Date:
Subject: Re: Understanding PG9.0 streaming replication feature