R: Cannot install Postgres Scanner #7892
Description
What happens?
I want to install the Postgres Scanner by sending queries from R, but get the following error message:
Error: rapi_execute: Failed to run query
Error: HTTP Error: Failed to download extension "postgres_scanner" at URL "http://extensions.duckdb.org/v0.8.0/windows_amd64_rtools/postgres_scanner.duckdb_extension.gz"
Extension "postgres_scanner" is an existing extension.
Are you using a development build? In this case, extensions might not (yet) be uploaded.
Session info:
R version 4.3.0 (2023-04-21 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19045)
Matrix products: default
locale:
[1] LC_COLLATE=English_Austria.utf8 LC_CTYPE=English_Austria.utf8 LC_MONETARY=English_Austria.utf8
[4] LC_NUMERIC=C LC_TIME=English_Austria.utf8
time zone: Europe/Vienna
tzcode source: internal
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] duckdb_0.8.0 DBI_1.1.3
loaded via a namespace (and not attached):
[1] compiler_4.3.0 tools_4.3.0 rstudioapi_0.14
To Reproduce
library(DBI)
library(duckdb)
con <- dbConnect(duckdb::duckdb(), dbdir = "my-db.duckdb", read_only = FALSE)
dbExecute(con, "INSTALL postgres")
OS:
Windows 10 x64 (build 19045)
DuckDB Version:
0.8.0
DuckDB Client:
R
Full Name:
Christoph Scheuch
Affiliation:
Tidy Finance
Have you tried this on the latest master branch?
- I agree
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- I agree