Do not return the column instead of raising an exception

[marwanhazemblnk]

What happens?

I have a column in PostgreSQL which is of type int4range, it raises an exception in POSTGRES_SCAN although it would be much useful to just print a warning message and ignore that column, due to raising such an exception I was not able to use the whole table although this field is not that important to me.

same goes with have a multi-dimensional array in PostgreSQL it raises an exception although it would be better to generate a warning and return the table without this specific column.

To Reproduce

To reproduce create a table
CREATE TABLE reservation (room int, during int4range);

you can find those exception in:

1. line 211 throw IOException("Unsupported Postgres type %s", pgtypename);
   2.line 783 throw NotImplementedException("Only one-dimensional Postgres arrays are supported");

OS:

Ubuntu

PostgreSQL Version:

psql (PostgreSQL) 14.1 (Debian 14.1-5)

DuckDB Version:

0.6.0

DuckDB Client:

c++ and cli

Full Name:

Marwan Hazem

Affiliation:

blnk

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