Re: Threads in PSQL - Mailing list pgsql-novice

From Tom Lane
Subject Re: Threads in PSQL
Date
Msg-id 3871.1069028092@sss.pgh.pa.us
Whole thread Raw
In response to Threads in PSQL  (Sergey Belikov <belikov@bnl.gov>)
List pgsql-novice
Sergey Belikov <belikov@bnl.gov> 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

pgsql-novice by date:

Previous
From: Sergey Belikov
Date:
Subject: Threads in PSQL
Next
From: Bruce Momjian
Date:
Subject: Re: problem with COPY command