On Fri, 2007-11-16 at 07:01 +0100, "König, Monika" wrote:
>
> 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 bu
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 s
On Thu, Nov 15, 2007 at 04:29:51PM +0100, "König, Monika" wrote:
> 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
There are logging options that should allow you to collect the DDL and then
parse it. You could then load it
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 sy
