help with rules for system table

Поиск
Список
Период
Сортировка
От rlhsiao@gmail.com
Тема help with rules for system table
Дата
Msg-id 1136774106.556459.29410@g47g2000cwa.googlegroups.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: userdefined types
Следующее
От: "Daniel Whitter"
Дата:
Сообщение: pg_dump creates bad dump / pgadmin crash issue