PQendcopy error in multithreading

From: Durgaprasad Pawar <durgaprasad(dot)pawar(at)yahoo(dot)co(dot)in>
To: pg novice <pgsql-novice(at)postgresql(dot)org>
Subject: PQendcopy error in multithreading
Date: 2007-09-11 05:39:20
Message-ID: 158667.93183.qm@web7703.mail.in.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I am trying to update multiple tables using the 'PQputline/PQendcopy' function. The code works fine if the tables are updated one after the other.
However, if there are multiple threads trying to copy data into different tables, the function fails. i.e. if one thread has started its copy operation and if some other thread also starts its copy operation (on different table), one of them fails.
Strangely, the PQputline function is successful for both the threads after the end delimiter is sent (\.).
What might be the reason for this PQendcopy failure? How do I get the exact error message after the failure?

---------------------------------
Download prohibited? No problem. CHAT from any browser, without download.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-09-11 08:24:15 Re: PQendcopy error in multithreading
Previous Message Tom Lane 2007-09-11 04:28:34 Re: Returning multiple values from a function