WillAyd opened a new issue, #1080:
URL: https://github.com/apache/arrow-adbc/issues/1080

   Found in the pandas test suite:
   
   ```python
   import pyarrow as pa
   import adbc_driver_manager
   from adbc_driver_postgresql import dbapi
   
   
   uri = "postgresql://postgres:postgres@localhost:5432/pandas"
   with dbapi.connect(uri) as conn:
       with conn.cursor() as cur:
           data = pa.array([1, 2, 4])
           tbl = pa.Table.from_arrays([data], names=["column"])
           cur.adbc_ingest("d1187b08-4943-4c8d-a7f6", tbl, mode="create")
   ```
   
   yields:
   
   ```sh
   OperationalError                          Traceback (most recent call last)
   Cell In[2], line 6
         4 data = pa.array([1, 2, 4])
         5 tbl = pa.Table.from_arrays([data], names=["column"])
   ----> 6 cur.adbc_ingest("d1187b08-4943-4c8d-a7f6", tbl, mode="create")
   
   File 
~/mambaforge/envs/pandas-dev/lib/python3.10/site-packages/adbc_driver_manager/dbapi.py:789,
 in Cursor.adbc_ingest(self, table_name, data, mode)
       786     self._stmt.bind_stream(handle)
       788 self._last_query = None
   --> 789 return self._stmt.execute_update()
   
   File 
~/mambaforge/envs/pandas-dev/lib/python3.10/site-packages/adbc_driver_manager/_lib.pyx:1050,
 in adbc_driver_manager._lib.AdbcStatement.execute_update()
   
   File 
~/mambaforge/envs/pandas-dev/lib/python3.10/site-packages/adbc_driver_manager/_lib.pyx:385,
 in adbc_driver_manager._lib.check_error()
   
   OperationalError: ADBC_STATUS_IO (10): [libpq] Failed to create table: 
ERROR:  syntax error at or near "-"
   LINE 1: CREATE TABLE d1187b08-4943-4c8d-a7f6 (column BIGINT)
                                ^
   
   Query was: CREATE TABLE d1187b08-4943-4c8d-a7f6 (column BIGINT)
   ```


-- 
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