help with rules for system table - Mailing list pgsql-general

From rlhsiao@gmail.com
Subject help with rules for system table
Date
Msg-id 1136774106.556459.29410@g47g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: help with rules for system table  (Jaime Casanova <systemguards@gmail.com>)
Re: help with rules for system table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: help with rules for system table  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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


pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: userdefined types
Next
From: "Daniel Whitter"
Date:
Subject: pg_dump creates bad dump / pgadmin crash issue