postgresql - Why am I not receiving this PG notification? -
i've opened 2 database consoles, using rails dbconsole
. issued following command in both of them:
listen ninja;
and, in second console, wrote:
notify ninja;
however, second console sees notification:
notify asynchronous notification "ninja" received server process pid 16837.
why aren't both consoles receiving notification? there setting can have both of them receive it?
i don't know rails dbconsole, psql program doesn't show notifications until next time execute command, because notifications pulled, not pushed, , console doesn't poll them while inactive. assume dbconsole similar.
Comments
Post a Comment