On Fri, 17 Jul 2020 at 20:44, Rita wrote:>
> curs = conn.cursor()
> curs.execute("LISTEN mychan0;")
> #curs.execute("LISTEN mychan1;") #fails!
> wait_select(conn)
Maybe you have to wait_select after each execute.
This example could be helpful.
I am trying to listen to multiple channels thru pg_notify mechanism.
select pg_notify('mychan0',foo');
select pg_notify('mychan'1,'bar');
In python I have something like this
import select,time
import psycopg2
import psycopg2.extensions
from psycopg2.extras import wait_select
DSN="dbname=mydb
