Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group