Re: Threads in PSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: belikov(at)bnl(dot)gov
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Threads in PSQL
Date: 2003-11-17 00:14:52
Message-ID: 3871.1069028092@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sergey Belikov <belikov(at)bnl(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2003-11-17 02:09:21 Re: problem with COPY command
Previous Message Sergey Belikov 2003-11-16 23:53:31 Threads in PSQL