Re: Threads in PSQL

Tom Lane wrote:

>Sergey Belikov  writes:
>
>>... Each thread 
>>creates it's own PGconn connection, and starts lo_export(conn, loid, 
>>filename) procedure. The problem is: after starting 2-3 threads SELECT 
>>query of the main program  fails because "another command is already in 
>>progress".
>>
>
>I'll bet lunch that you have not actually created a PGconn for each
>thread --- or else that one of the threads is using the wrong PGconn
>object.
>
>			regards, tom lane
>
Hi Tom!
You won! The probelm was not PGConns, but my main thread - I'm using 
non-blocking psql  functions - I have to implement setQueryTimeout 
mechanism myself because it is ignored (by now) by PSQL/ODBC driver. And 
it looks like I was sending two queries without waiting while the first 
one completes.
At least now my program works properly.
Thank you, Sergey.