Re: Adding ddl audit trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Lawrence Cohan <LCohan(at)web(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Adding ddl audit trigger
Date: 2011-01-26 22:13:38
Message-ID: 26956.1296080018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guillaume Lelarge <guillaume(at)lelarge(dot)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 this 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".

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Birken 2011-01-26 22:22:41 Re: Understanding PG9.0 streaming replication feature
Previous Message Guillaume Lelarge 2011-01-26 21:54:34 Re: Adding ddl audit trigger