[Pypgsql-devel] demo2a.py crashes

[Michael H. <Michael@Hipp.com>]

Hello,

Playing around with the "notify" capability, but I find that demo2a.py
regularly crashes. It will do this fairly consistently after 3 - 4
notifications have been received. I'm using the demo2a file unmodified
except for using my own database/table info. I'm using psql to do
"NOTIFY mytable;".

It seems to crash on the line indicated below.

while 1:
     # Wait a little (using select())
     sys.stdout.flush()
     ready_sockets = select.select([cnx.socket], [], [], 1.0)[0]
     if len(ready_sockets) == 0:
         sys.stdout.write('.')
     else:
         sys.stdout.write('\n')
         cnx.consumeInput()
         note = cnx.notifies()  <--- Crashes here
         while note:

I'm on Win2k using PostgreSQL 8.0.3, Python 2.4.1 and the version of
pyPgSQL released by Gerhard that works with the above.

The symptom is the program freezes and Windows reports that "python.exe
has generated errors and will be closed". Windows reports it is creating
a log, but I can't seem to find it.

Any ideas?

Thanks,
Michael Hipp