Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7wIc-0007YI-RS for psycopg@arkaria.postgresql.org; Thu, 04 Oct 2018 05:35:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g7wIZ-0006mu-8n for psycopg@arkaria.postgresql.org; Thu, 04 Oct 2018 05:35:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7wIY-0006m7-UX for psycopg@lists.postgresql.org; Thu, 04 Oct 2018 05:35:43 +0000 Received: from mail-qt1-x841.google.com ([2607:f8b0:4864:20::841]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g7wIO-0003DQ-Qx for psycopg@postgresql.org; Thu, 04 Oct 2018 05:35:40 +0000 Received: by mail-qt1-x841.google.com with SMTP id q40-v6so8610186qte.0 for ; Wed, 03 Oct 2018 22:35:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=WRxVtL+XAGRRbgd+UJIJLW160UtcY8gux5YFqNnW+jY=; b=RIUIKk+rURLnlDIUrNVc1blrmu9rJhjwJUbJIRo9bUm33RuaGJpo5QLOZ5Hw8QteVr b81C5uTUhcv6h9ubtB+xN9dgqiAvuQIJdRDZxV2b1FFoZZMbWfSqjnFoN6UOi6CTGZr/ lhNhl2GfbOlIfxiDGCRom3E64k6IEy+x7/zmzAbmToVGtKyfOFMxewNdpXAjWAeJOc6u yj58VUv9Or44MMViO6s1OFkhVxURnxzVGtiEUEnPrT5fEOL3VrmCW7Bw83ZdIbfGKvz9 EunDDR93DSjonOQg/frFbQ7Bj996mZpMvSMo5wXsPFB8jEmpy9W/qHsWkjV/Q2gm4Ta2 R05Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=WRxVtL+XAGRRbgd+UJIJLW160UtcY8gux5YFqNnW+jY=; b=hs5VZgbHVaCKKc47/yPYQXc+aLas9s8l8GfovzrZXR99wgtmTfZigPUOvnbcgLGGXw NaRsswk+7BrTrwv88GAbqQ+VA0fOE/bdrq3DFyHKRyxju7vxPfXcSBWfBSJZGSFu03Oe C/zyMTNNmZacj6qPDuKFPgroqIz75VNiYmb32u9bI5I5Tc3BNhqchW2cBVfmTOSQcTdr RsRtDfXOqo1ML8MKAZZ6+rNEX2GOKF3/Rjlw0ocAh8bov77FWiSOnLH4q9SYAwx7ol0Y jYSoSGBh3xcOlmBYtlQUW4jo5vFlWhG3VcOkkPVyxB3ljSMSAkl0HK5TsijGjwoepzS/ Cnsw== X-Gm-Message-State: ABuFfoiweg3EdMOF8w86xHIgLkM9fbGR8NRCyLNELs/UHZ6xtlDYt73D 5rLwSZfaw2N92DGD567NusJOTPJxDjoCnPDJ5iQcMvzu2R2KMw== X-Google-Smtp-Source: ACcGV62p/o1fP+1BvKwqBgtsnrbga9ZuPJeDSLDk5+05hk5z50GOhyzORoun3a24kqWgHR6Vs+NreP39euHeMYpMn2s= X-Received: by 2002:aed:21d7:: with SMTP id m23-v6mr4027494qtc.121.1538631330225; Wed, 03 Oct 2018 22:35:30 -0700 (PDT) MIME-Version: 1.0 From: Akshay Joshi Date: Thu, 4 Oct 2018 11:05:19 +0530 Message-ID: Subject: Copy command hangs in poll() function To: psycopg@postgresql.org Content-Type: multipart/alternative; boundary="000000000000e0f9360577608594" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000e0f9360577608594 Content-Type: text/plain; charset="UTF-8" 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* --000000000000e0f9360577608594 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello=C2=A0

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

If copy command not supported then at least it should not hang the appli= cation. poll() function should return the proper error message.=C2=A0
=

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

-= -
Akshay Joshi
S= r. Software Architect

=

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