Re: Triggers and System Tables - Mailing list pgsql-general

From Hans-Juergen Schoenig
Subject Re: Triggers and System Tables
Date
Msg-id 3CBC4DC0.6050800@cybertec.at
Whole thread Raw
In response to Re: Triggers and System Tables  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-general
My problem is that there is no simple way to find out when a table has
been created. I need something like a trigger on pg_class so that I can
check for new tables.
Is there a way to get around the problem?
I know that system tables are somehow special and that is not
recommended to implement some sort of "ordinary trigger" due to internal
reasons.
I wonder how I can find out that a table, a view or something like that
has been created if there is no way to start a function automatically.

Does anybody have an idea?

    Hans


pgsql-general by date:

Previous
From: mdklatt@ou.edu (Michael Klatt)
Date:
Subject: Re: Perplexing Query Performance
Next
From: "Marin Dimitrov"
Date:
Subject: Re: user question about log