"Peter Koczan" <pjkoczan(at)gmail(dot)com> writes:
> For instance, I can open up two connections on my test server and
> illustrate the problem.
Well, the fact that psql acts that way is not unexpected, because it
doesn't monitor the database connection constantly --- when it's waiting
for console input, it just sleeps. It's not so much "send a NOTIFY"
that wakes it up, as "do anything at all with the database connection".
What you've told us so far about your own application doesn't suggest
that it would need to be told to send a notify before it remembered to
check for input, but maybe there's some interaction there that you
missed.
regards, tom lane