create rule ... as on insert

From: Omachonu Ogali <missnglnk(at)informationwave(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: create rule ... as on insert
Date: 2005-06-24 15:05:32
Message-ID: 20050624150532.GA55405@dipole.informationwave.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

db=# select * from xyz;
(2 rows)

Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
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 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.

db=# select * from xyz;
(2 rows)

Asynchronous notification "xyz_inserted" received from server process with PID 48438.

db=# select * from xyz;
(2 rows)

Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48442.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.

db=# select * from xyz;
(2 rows)

Asynchronous notification "xyz_inserted" received from server process with PID 48436.
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 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48444.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
Asynchronous notification "xyz_inserted" received from server process with PID 48444.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48442.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48445.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48445.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
Asynchronous notification "xyz_inserted" received from server process with PID 48440.
Asynchronous notification "xyz_inserted" received from server process with PID 48445.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48442.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
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 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48445.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
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 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48433.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48445.
Asynchronous notification "xyz_inserted" received from server process with PID 48442.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48445.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.

db=# unlisten xyz_inserted;
UNLISTEN
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48436.
Asynchronous notification "xyz_inserted" received from server process with PID 48442.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48443.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.
Asynchronous notification "xyz_inserted" received from server process with PID 48434.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48437.
Asynchronous notification "xyz_inserted" received from server process with PID 48438.
Asynchronous notification "xyz_inserted" received from server process with PID 48442.
Asynchronous notification "xyz_inserted" received from server process with PID 48441.
Asynchronous notification "xyz_inserted" received from server process with PID 48435.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Gold 2005-06-24 15:06:06 Re: Postmaster Out of Memory
Previous Message Scott Marlowe 2005-06-24 14:45:15 Re: problem calling psql from another program