GitHub user paleolimbot added a comment to the discussion: Querying PostgreSQL 
generate_subscripts from Python with a dimension from bound parameters

> Ah, if that's not implemented, we should do that...

>From the libpq docs ( https://www.postgresql.org/docs/8.1/libpq-exec.html )

> At present, there is no way to determine the actual data type inferred for 
> any parameters whose types are not specified in paramTypes[]. This is a libpq 
> omission that will probably be rectified in a future release.

We could maybe expose binding things as strings instead of COPY and let 
Postgres figure it out, or have a custom inference per engine (e.g., Postgres 
infers Python integers as int32 by default, but sqlite3 infers them as int64s?)

GitHub link: 
https://github.com/apache/arrow-adbc/discussions/2865#discussioncomment-13277565

----
This is an automatically sent email for user@arrow.apache.org.
To unsubscribe, please send an email to: user-unsubscr...@arrow.apache.org

Reply via email to