Re: create rule ... as on insert

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 has been inserted into the table.
>
> db=# create rule xyz_inserts as on insert to xyz do notify xyz_inserted;
> CREATE RULE
> db=# listen xyz_inserted;
> LISTEN
> db=# notify xyz_inserted;
> NOTIFY
> Asynchronous notification "xyz_inserted" received from server process with PID 48442.
> Asynchronous notification "xyz_inserted" received from server process with PID 48433.
> Asynchronous notification "xyz_inserted" received from server process with PID 48445.
> Asynchronous notification "xyz_inserted" received from server process with PID 48436.
> Asynchronous notification "xyz_inserted" received from server process with PID 48435.
> Asynchronous notification "xyz_inserted" received from server process with PID 44586.
>
> All is well up until this point...I'm not too sure about the multiple
> notifications, but the number I receive just continues to grow and grow
> even though there are multiple notifications coming from the same
> processes, over and over.
>
> I'm the only one with full rights to this table, and the only one that
> is currently working on this database. There is another rule that I've
> created (and is currently active), that does inserts into xyz from
> another table, but as you can see below, there are no new inserts.

Can you post a short "test case" that demonstrates this behaviour?