lidavidm commented on issue #1045:
URL: https://github.com/apache/arrow-adbc/issues/1045#issuecomment-1710474911
```
>>> import adbc_driver_postgresql.dbapi
>>> conn =
adbc_driver_postgresql.dbapi.connect('postgres://postgres:password@localhost:5432/postgres')
>>> cur = conn.cursor()
>>> cur.execute('CREATE TEMPORARY TABLE "fa673c6fae1b49c88c5741c569c444d8"
AS ("foo" BIGINT);')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File
"/home/lidavidm/venv/lib/python3.10/site-packages/adbc_driver_manager/dbapi.py",
line 622, in execute
handle, self._rowcount = self._stmt.execute_query()
File "adbc_driver_manager/_lib.pyx", line 1009, in
adbc_driver_manager._lib.AdbcStatement.execute_query
File "adbc_driver_manager/_lib.pyx", line 399, in
adbc_driver_manager._lib.check_error
adbc_driver_manager.OperationalError: IO: [libpq] Failed to execute query:
could not infer schema: failed to prepare query: ERROR: syntax error at or
near ""foo""
LINE 1: ...RARY TABLE "fa673c6fae1b49c88c5741c569c444d8" AS ("foo" BIGI...
>>> conn.rollback()
>>> cur.execute('CREATE TEMPORARY TABLE "fa673c6fae1b49c88c5741c569c444d8"
("foo" 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]
