Hi, I'm a brand-new member of the list. I hope someone can solve my problem... I'm trying to write an event watcher that uses DBD::Pg (a patched version of the driver) that recognizes the LISTEN/NOTIFY event processing. Basically, when a new "job" is written to the "job queue" table, the process writing the new entry issues NOTIFY "NEW_<foo>_JOB" and the <foo>-handling process, having issued a LISTEN "NEW_<foo>_JOB" would catch this as an event and go to work. I've used Event.pm to set up an 'io' type event on the database's fd. The problem is that my callback is getting invoked over and over, even though there's only one NOTIFY being sent. (I'm issuing the NOTIFY from a SQL prompt.) Do I have to do something to clear the event after I process it? I've tried issuing a sysread() against the fd, but that didn't help. -- Jeff Boes vox 616.226.9550 Database Engineer fax 616.349.9076 Nexcerpt, Inc. [EMAIL PROTECTED]
