[GitHub] [arrow-adbc] mcrumiller commented on issue #538: RuntimeError: Cannot close AdbcConnection with open AdbcStatement

Tue, 27 Jun 2023 11:15:33 -0700 


mcrumiller commented on issue #538:
URL: https://github.com/apache/arrow-adbc/issues/538#issuecomment-1610003536

   Thanks for your help David. I think the issue is in the `(FORMAT binary)` 
part of the `COPY TO` statement.
   
   ```
   Traceback (most recent call last):
     File "<string>", line 1, in <module>
     File "adbc_driver_manager\_lib.pyx", line 991, in 
adbc_driver_manager._lib.AdbcStatement.execute_query
     File "adbc_driver_manager\_lib.pyx", line 385, in 
adbc_driver_manager._lib.check_error
   adbc_driver_manager._lib.OperationalError: ADBC_STATUS_IO (10): [libpq] 
Failed to execute query: could not begin COPY: ERROR:  syntax error at or near 
"("
   LINE 1: ...= '2023-05-10'::DATE ORDER BY plcy_nbr) TO STDOUT (FORMAT bi...
   ```
   
   When I run this in my handy DBeaver postgresql app, I get this error:
   
   
![image](https://github.com/apache/arrow-adbc/assets/1896992/c113105a-ee0e-4aab-a9ec-d755f26acb92)
   
   
   But note that when I run without the `FORMAT binary`, it works (but fails 
for a different reason, DBeaver uses jdbc):
   
   
![image](https://github.com/apache/arrow-adbc/assets/1896992/ea8bf9b0-165f-42d6-a6d9-211204a292d5)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to