Re: PQendcopy error in multithreading - Mailing list pgsql-novice

From Sean Davis
Subject Re: PQendcopy error in multithreading
Date
Msg-id 46E650AF.8010901@mail.nih.gov
Whole thread Raw
In response to PQendcopy error in multithreading  (Durgaprasad Pawar <durgaprasad.pawar@yahoo.co.in>)
List pgsql-novice
Durgaprasad Pawar wrote:
> 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?

Are you trying to do this using the same connection in different
threads, or does each thread have its own connection?  I suspect you are
trying to do the former.

Sean

pgsql-novice by date:

Previous
From: Durgaprasad Pawar
Date:
Subject: PQendcopy error in multithreading
Next
From: Sean Davis
Date:
Subject: Re: PQendcopy error in multithreading