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

   We need to implement this. This should be possible via `PQdescribePrepared`: 
https://www.postgresql.org/docs/current/libpq-exec.html#LIBPQ-PQDESCRIBEPREPARED
   
   > The context is that I'm making a SQLAlchemy Dialect for PostgreSQL/ADBC
   
   Awesome!
   
   > How can I get ADBC to assume that it's just an INT?
   
   I think in this case it's coming from pyarrow, which picks int64 as its 
default inference of an arbitrary Python integer:
   
   
https://github.com/apache/arrow-adbc/blob/5721207931003695162bbe246991144313f40c48/python/adbc_driver_manager/adbc_driver_manager/dbapi.py#L707
   
   It's a great point that the default conversion to BIGINT is likely to cause 
some problems. I forget from when I was working on this whether libpq gives us 
the opportunity to query the parameter types that *it* thinks we should be 
using from an arbitrary query (it looks like it isn't implemented from our 
side, anyway):
   
   
https://github.com/apache/arrow-adbc/blob/5721207931003695162bbe246991144313f40c48/c/driver/postgresql/statement.cc#L763-L766
   
   _Originally posted by @paleolimbot in 
https://github.com/apache/arrow-adbc/discussions/2865#discussioncomment-13275239_


-- 
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: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to