Support for array of macaddr

[kamilcglr]

What happens?

Hello,

I have a postgresql table with an array column of mac addresses. I can't read the table from duckdb. I have the following error: Error: INTERNAL Error: Unsupported type for ColumnDataCollection::GetCopyFunction

It seems that macaddr is not supported here. It would fine to have a conversion to varchar.

To Reproduce

In postgresql:

CREATE TABLE test
(
    mac_addresses macaddr[]
);

TRUNCATE test;
INSERT INTO test (mac_addresses)
VALUES ( '{00:00:00:00:00:00, 00:00:00:00:00:01, 00:00:00:00:00:02}'::macaddr[] );

In duckdb:

INSTALL
postgres_scanner;
    LOAD
postgres_scanner;

CALL postgres_attach('***);

SELECT * FROM test;
-- gives Error: INTERNAL Error: Unsupported type for ColumnDataCollection::GetCopyFunction

OS:

macOS

PostgreSQL Version:

15

DuckDB Version:

0.7.1

DuckDB Client:

CLI

Full Name:

Kamil Caglar

Affiliation:

Serenicity

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

[HackettJP]

would this work ? it be VARCHAR ...

this is my POC code output ...

[Mytherin]

Thanks for the report! This should be fixed now in #111.