Alvaro Herrera <alvhe...@commandprompt.com> writes: > I was thinking that the connection would be kept open but no query would > be running. Does this preclude reception of notifies? I mean, you > don't sleep via "SELECT pg_sleep()" but rather a select/poll in the > daemon.
No. If you're not inside a transaction, notifies will be sent immediately. They'd be pretty useless if they didn't work that way --- the whole point is for clients not to have to busy-wait. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers