Unsupported Postgres domain type

[Leo-XM-Zeng]

What happens?

postgres=# create table basictest
postgres-#            ( testint4 domainint4
postgres(#            , testtext domaintext
postgres(#            , testvarchar domainvarchar
postgres(#            , testnumeric domainnumeric
postgres(#            );
CREATE TABLE
postgres=# 
postgres=# INSERT INTO basictest values ('88', 'haha', 'short', '123.12');
INSERT 0 1
postgres=# select * from basictest;
2025-01-01 23:09:25.190 CST [1116620] WARNING:  01000: (PGDuckDB/GetPostgresDuckDBType) Could not convert DuckDB type: "UnsupportedPostgresType (Oid=245756)" to Postgres type
2025-01-01 23:09:25.190 CST [1116620] LOCATION:  GetPostgresDuckDBType, pgduckdb_types.cpp:978
2025-01-01 23:09:25.191 CST [1116620] WARNING:  01000: (PGDuckDB/CreatePlan) Cache lookup failed for type 0
2025-01-01 23:09:25.191 CST [1116620] LOCATION:  CreatePlan, pgduckdb_planner.cpp:77
WARNING:  (PGDuckDB/GetPostgresDuckDBType) Could not convert DuckDB type: "UnsupportedPostgresType (Oid=245756)" to Postgres type
WARNING:  (PGDuckDB/Create

To Reproduce

create domain domainvarchar varchar(5);
create domain domainnumeric numeric(8,2);
create domain domainint4 int4;
create domain domaintext text;

-- Test tables using domains
create table basictest
           ( testint4 domainint4
           , testtext domaintext
           , testvarchar domainvarchar
           , testnumeric domainnumeric
           );

INSERT INTO basictest values ('88', 'haha', 'short'); 
select * from basictest;

OS:

centos8

pg_duckdb Version (if built from source use commit hash):

main

Postgres Version (if built from source use commit hash):

16.6

Hardware:

No response

Full Name:

Man Zeng

Affiliation:

Halo

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

• Yes, I have