Re: LISTEN/NOTIFY enhancement: Portable signal handling?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sean Chittenden <sean@chittenden.org>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-12-27T17:41:07Z
Lists: pgsql-hackers
Sean Chittenden <sean@chittenden.org> writes:
> The async interface is nice, but not really useful to me as it requires 
> polling, instead of unblocking when an event comes through, which would 
> create a vastly more real time interface that should be easier on the 
> database.

BTW, this is nonsense; the backend sends a message exactly when the
NOTIFY occurs.  It may well be that libpq needs some work to make it
easier to wait for a NOTIFY without polling, but again there isn't a
reason to clutter the server-side code with it.

			regards, tom lane