v.1.4.4 fails to install spatial extension

[StefanoMezzini]

Attempting to use spatial objects with {duckdb} v.1.4.4 was resulting in the error

Error in `duckdb_result()`:
! Invalid Error: HTTP Error: Failed to download extension "spatial" at URL "http://extensions.duckdb.org/123e15dc2d/osx_arm64/spatial.duckdb_extension.gz" (HTTP 404)
Extension "spatial" is an existing extension.

The same error occurs with the CRAN version of the package.

The URL listed in the error does indeed result in a 404, likely because the version it is trying to find is a nightly version. Reverting to v.1.4.3 with

remotes::install_github("duckdb/duckdb-r@v1.4.3") 

resolved the issue.

[krlmlr]

Thanks. I just installed duckdb from source (https://github.com/cran/duckdb) and couldn't reproduce it.

duckdb::sql_exec("INSTALL spatial")
## [1] 0

Same with an install from a CRAN binary on macOS.

From the duckdb sources, the source ID 123e15dc2d corresponds to the most recent version of the main branch, 1153d17#diff-59b479705825ddbee4c624190617ba1cfea3f826c0987d3d5e589ff34a9a9a57R14 .

The same error occurs with the CRAN version of the package.

This can happen if you don't restart R after installing another version of the package that's already loaded.

Can you please try again?

[krlmlr]

Extensions only work with the GitHub version of the package if they have been built for it.

[StefanoMezzini]

thank you for the quick response. I just updated {duckdb} with remotes::install_github("duckdb/duckdb-r") to v.1.4.4.9003, and seems to work without any issues now.