What happens?

duckdb -ui
docker run -v pgdata:/var/lib/postgresql/data -p 5433:5432 -d --name pg_duckdb -e POSTGRES_PASSWORD=duckdb pgduckdb/pgduckdb:17-main

INSTALL postgres;
LOAD postgres;
ATTACH 'dbname=postgres user=postgres host=127.0.0.1 port=5433 password=duckdb ' AS db (TYPE postgres, READ_ONLY, SCHEMA 'duckdb');

To Reproduce

An error has occurred:

Invalid Error: Failed to execute query "BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ READ ONLY": ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query

OS:

Liunx

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

pgduckdb/pgduckdb:17-main

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

17

Hardware:

No response

Full Name:

JZ

Affiliation:

CTO

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?

No - Other reason (please specify in the issue body)

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