postgres_scanner

postgres_scanner copied to clipboard

What happens?

What would it take to build binaries that can be used in R for Windows?

The spatial extension seems to work already: https://github.com/duckdb/duckdb-r/issues/23#issuecomment-1985276933

This extension can be made to work too, it seems: https://github.com/duckdb/duckdb-r/issues/23#issuecomment-2002374602

CC @elysabethpc.

CC @Maxxen (re: https://github.com/duckdb/duckdb-r/issues/100#issuecomment-1980517821)

To Reproduce

con <- DBI::dbConnect(duckdb::duckdb())
DBI::dbExecute(con, "install postgres_scanner;")

OS:

Windows

PostgreSQL Version:

?

DuckDB Version:

0.10.0

DuckDB Client:

R

Full Name:

Kirill Müller

Affiliation:

cynkra GmbH

Have you tried this on the latest main branch?

• [X] 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?

• [X] I agree

I've been trying to install/load postgres_scanner without success. I was able to install the gz file locally and tried installing after decompressing the file, but I get this error: The file was built for the platform 'windows_amd64', but we can only load extensions built for platform 'windows_amd64_rtools'.

I've been digging around and can't seem to find a solution for this extension to work on windows. So I'm wondering if there is a solution that I'm missing, or if it's something in the works that isn't available yet?