"Rod Taylor" <rbt(at)zort(dot)ca> writes:
> Sorry, NOTIFY -- not NOTICE (damn keyboard...)
> Right now we're required to do a select against the database
> periodically
Certainly not; I fixed that years ago (I think it was the first
nontrivial thing I ever did with the PostgreSQL code). You can
execute PQnotifies without any PQexecs, and you can even have your
application sleep waiting for a notify to come in. See the libpq
docs under the heading of "Asynchronous Notification".
regards, tom lane