Adam Haberlach <adam@newsnipple.com> writes:
> This always seems to time out. Is there some mode that I need to put
> the backend into in order to make the socket valid?
It seems like there should be a loop around the
select/consumeinput/notifies sequence, but perhaps that's provided
outside the pqwait() function? As it stands, you're assuming that
the first data delivered will be the notify you want.
Another possible problem is if you are expecting this to fire within
a transaction block. Notifications are only delivered outside of
transactions.
regards, tom lane