You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "lidavidm (via GitHub)" <gi...@apache.org> on 2023/03/24 16:56:53 UTC
[GitHub] [arrow-adbc] lidavidm opened a new issue, #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
lidavidm opened a new issue, #540:
URL: https://github.com/apache/arrow-adbc/issues/540
Right now unless you ExecuteUpdate, it will always try to infer the schema and use COPY. We could fall back to executing the query normally and not using COPY to handle things like CREATE/DROP TABLE (since Python DBAPI doesn't differentiate between the two as much).
--
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-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-adbc] paleolimbot commented on issue #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
Posted by "paleolimbot (via GitHub)" <gi...@apache.org>.
paleolimbot commented on issue #540:
URL: https://github.com/apache/arrow-adbc/issues/540#issuecomment-1483161122
I noticed this when attempting to wrap it in R but I forgot/didn't know about ExecuteUpdate. R's DBI usually executes create/drop table using `DBI::dbExecute()` instead of `DBI::dbFetchQuery()` so it's probably fine from DBI's end, anyway.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-adbc] lidavidm commented on issue #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
Posted by "lidavidm (via GitHub)" <gi...@apache.org>.
lidavidm commented on issue #540:
URL: https://github.com/apache/arrow-adbc/issues/540#issuecomment-1584757445
This was duplicated in #701/fixed in https://github.com/apache/arrow-adbc/commit/a6bd37a9f2189b41d6f7a70f10ee72ef6d615aab.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-adbc] paleolimbot commented on issue #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
Posted by "paleolimbot (via GitHub)" <gi...@apache.org>.
paleolimbot commented on issue #540:
URL: https://github.com/apache/arrow-adbc/issues/540#issuecomment-1483286222
Ah right! I think I didn't expose that properly in the driver manager.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-adbc] lidavidm commented on issue #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
Posted by "lidavidm (via GitHub)" <gi...@apache.org>.
lidavidm commented on issue #540:
URL: https://github.com/apache/arrow-adbc/issues/540#issuecomment-1483173774
Yeah, I figure we should be non surprising (also, there isn't an actual ExecuteUpdate, it's just ExecuteQuery without an output ArrowArrayStream)
On Fri, Mar 24, 2023, at 13:24, Dewey Dunnington wrote:
>
>
> I noticed this when attempting to wrap it in R but I forgot/didn't know about ExecuteUpdate. R's DBI usually executes create/drop table using `DBI::dbExecute()` instead of `DBI::dbFetchQuery()` so it's probably fine from DBI's end, anyway.
>
>
> —
> Reply to this email directly, view it on GitHub <https://github.com/apache/arrow-adbc/issues/540#issuecomment-1483161122>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AACQB36NWR3JUA5ZVH6A653W5XKGPANCNFSM6AAAAAAWGZYILI>.
> You are receiving this because you authored the thread.Message ID: ***@***.***>
>
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-adbc] lidavidm closed issue #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
Posted by "lidavidm (via GitHub)" <gi...@apache.org>.
lidavidm closed issue #540: c/driver/postgresql: support non-SELECT queries in ExecuteQuery
URL: https://github.com/apache/arrow-adbc/issues/540
--
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-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org