Re: Triggers and System Tables

From: Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers and System Tables
Date: 2002-04-16 16:13:52
Message-ID: 3CBC4DC0.6050800@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tarabas 2002-04-16 16:25:11 Wrong sort-order
Previous Message Neil Conway 2002-04-16 16:08:01 Re: function for creating random id