In pg_clickhouse inserting into a ClickHouse table that contains a UUID column fails with:

pg_clickhouse: could not append data to column - unexpected column type for 2950: UUID

This happens even though the documentation states that ClickHouse UUID maps to PostgreSQL uuid.

The issue appears to affect the INSERT / COPY write path only. Reading from UUID columns works correctly.

ClickHouse table

CREATE TABLE test.uuid_test (
    id UUID,
    value String
) ENGINE = MergeTree()
ORDER BY id;

Postgres Query

INSERT INTO test.uuid_test (id, value)
VALUES (
  '550e8400-e29b-41d4-a716-446655440000',
  'hello'
);