help with rules for system table

From: rlhsiao(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: help with rules for system table
Date: 2006-01-09 02:35:06
Message-ID: 1136774106.556459.29410@g47g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have to archieve functions like this:
When users define a new index, I will do something (for instance,
increase an counter in my table or do some other statistics). However,
I defined rule for insert on pg_class and when the entry is actually an
index, I do my thing. Obviously my rule is never executed. If I create
a similar rule for a table I defined, it works. Does this mean that I
can't create rules for system tables? If not, does anyone know how to
do this?

Any suggestions or solutions are appreciated.

Thanks,
Ruey-Lung Hsiao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Stookey 2006-01-09 03:43:24 Functions as a Security Layer
Previous Message Postgres User 2006-01-09 00:54:45 Re: Installing Postgres 8.1 on Windows Server 2003 R2