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

trigger ddl actions in a table

From: "König, Monika" <monika(dot)koenig(at)bonn(dot)de>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: trigger ddl actions in a table
Date: 2007-11-15 15:29:51
Message-ID: 1C2329C9430609409808ECF10237287612EA4CC7@mydomain.com (view raw or flat)
Thread:
Lists: pgsql-admin
I need a way for logging every action on the system catalog. I must have a
table which shows when a tables was created or updated or deleted. I need
the date  of the change .

I tried to make an trigger on pg_catalog.pg_class but this throws an error :
"ERROR: permission denied: "pg_class" is a system catalog".

I can see all ddl in my log files, but 
	- there are even the errors in and 
	- i can't use it for a select


Is there an possibility for having such an system-action table??



Thanks

Monika König






Responses

pgsql-admin by date

Next:From: König, MonikaDate: 2007-11-15 15:33:34
Subject: functions pg_get...
Previous:From: Chris HooverDate: 2007-11-15 15:14:41
Subject: any way to make query use index?

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