Copy command hangs in poll() function

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Copy command hangs in poll() function
Date: 2018-10-04 05:35:19
Message-ID: CANxoLDekyavcxjh1yWk1hhB1ER+YvxUkg1ZP2DOYev+Mr1FULw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello

As per documentation http://initd.org/psycopg/docs/advanced.html Copy
commands are not supported in asynchronous mode, but this will be probably
implemented in a future release. In pgAdmin4 (open source) we have used
async connection to run the SQL query on PostgreSQL database and uses
poll() function to poll the results. When user runs any *COPY *command
application hangs at poll() function.

If copy command not supported then at least it should not hang the
application. poll() function should return the proper error message.

Can you please provide that fix until support for copy command won't come.

--
*Akshay Joshi*

*Sr. Software Architect *

*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2018-10-04 09:32:35 Re: Integration of Psycopg with XTA
Previous Message Christian Ferrari 2018-10-03 20:50:08 Re: Integration of Psycopg with XTA