[GENERAL] create rule ... as on insert

2005-06-24 Thread Omachonu Ogali
I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules. I created a rule to watch for any inserts to table XYZ, and registered a listener. But as I simply do a select on the table, I receive several notifications when nothing has been inserted into the table. db=# create rule

Re: [GENERAL] create rule ... as on insert

2005-06-24 Thread Scott Marlowe
On Fri, 2005-06-24 at 10:05, Omachonu Ogali wrote: I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules. I created a rule to watch for any inserts to table XYZ, and registered a listener. But as I simply do a select on the table, I receive several notifications when nothing

Re: [GENERAL] create rule ... as on insert

2005-06-24 Thread Janning Vygen
Am Freitag, 24. Juni 2005 17:05 schrieb Omachonu Ogali: I'm using PostgreSQL 7.4.2, and I'm having a little issue with rules. I created a rule to watch for any inserts to table XYZ, and registered a listener. But as I simply do a select on the table, I receive several notifications when