Re: [GENERAL] help with rules for system table

2006-01-10 Thread Jim Nasby
Adding -general back into this... No, I don't think there's any way to trigger on this programmatically, though there has been talk from time-to-time about adding support for triggers on DDL. In the meantime you'll just need to scan the system tables for new indexes. I'm also wondering if there

Re: [GENERAL] help with rules for system table

2006-01-10 Thread Jim C. Nasby
On Sun, Jan 08, 2006 at 06:35:06PM -0800, [EMAIL PROTECTED] wrote: > 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_cl

Re: [GENERAL] help with rules for system table

2006-01-09 Thread Tom Lane
[EMAIL PROTECTED] writes: > Does this mean that I can't create rules for system tables? Not ones that will be invoked by system operations, anyway. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postma

Re: [GENERAL] help with rules for system table

2006-01-09 Thread Jaime Casanova
> Does this mean that I can't create rules for system tables? that's right... you cannot create rules for system tables... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner w