Hi guys, thanks for fixing the error with connecting to a pooler. It fixed pgpool as well. I meant to submit a bug on that before. My issue seems to be that there are intermittent times when I'm unable to write via cursor.execute when connecting via pgpool. (I thought it was working earlier today when I made this bare code..?) I can't replicate the issue at all when connecting directly. I can see that it is matching the code to quit but it seems like nothing is getting sent to the server, as verified in the postgres logs. I can create a new connection via pgpool and that works fine. Is there something I'm doing wrong? Also at this point, I'm unable to control-c out of the program or kill it. Here's my simplified code:

!/usr/bin/python26

import select
import psycopg2
import psycopg2.extensions

conn = psycopg2.connect("dbname=jobs user=postgres host=localhost port=9999")
conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT)

curs = conn.cursor()
curs.execute("LISTEN test; LISTEN test_quit;")

while 1:

    if select.select([conn],[],[],5) == ([],[],[]):
            print ""
    else:
     try:
            conn.poll()

            while conn.notifies:
                    noti = conn.notifies.pop(0)
                    print "Got NOTIFY:", noti

                    if noti[1] == "test":
                            print "test"
                    elif noti[1] == "test_quit":
                            print "QUIT"
                            curs.execute("UNLISTEN test; UNLISTEN test_quit;")
                            curs.close();
                            conn.close();
     except Exception, data:
            print data
            pass