trigger ddl actions in a table - Mailing list pgsql-admin

From König, Monika
Subject trigger ddl actions in a table
Date
Msg-id 1C2329C9430609409808ECF10237287612EA4CCA@mydomain.com
Whole thread Raw
Responses Re: trigger ddl actions in a table  (Brad Nicholson <bnichols@ca.afilias.info>)
List 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






pgsql-admin by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Upgrading a database with pg_dumpall / psql ...
Next
From: "Chris Hoover"
Date:
Subject: Does copy increment pg_stat_user_tables.seq_scan?