Hi everybody,

Sorry for posting here but I haven't found any forum or help mailing list
where I could post this.

First thanks for the job on PyGreSQL. I've been using it on a huge project
for the past 8 months.

Here is my question : I'm writing a multi-threaded server app that uses a
pgdb connection. One thread is in charge of all the communication through
pgdb and the other threads pass it their queries in a queue and wait for
for the result to be available. Some queries might need several minutes
before returning, so I'd like to be able to timeout those quieries so that
they do not block the other threads waiting for data too.

I've tried to close the cursor and even the connection while the execute
statement is running but it always waits for the cursor.execute() statement
to return before raising an exception.

Is there a way of aborting the execution of an SQL statement ?

Thanks again,

Olivier

_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql

Reply via email to