Can't create table with geometry field

[fnicastri]

What happens?

trying to create a table in a remote Postgis database wuth create table postgres_db.test_table (id int, location geometry ); duckdb return a generic error:

INTERNAL Error: Unsupported logical type for RemoveAlias
This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/dev/internal_errors

To Reproduce

load/install the postgres extension load/install the spatial extension attach a postgres database

try to create a table with a geometry column: create table postgres_db.test_table (id int, location geometry );

OS:

mac/linux

PostgreSQL Version:

16 + PostGIS 3.4.2

DuckDB Version:

v1.1.0 fa5c2fe15f (nightly)

DuckDB Client:

cli/python

Full Name:

Francesco Nicastri

Affiliation:

myself

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

[ken2190]

same problem here

[Hajna]

same problem, this is probably expected though