search

alitrack / duckdb_fdw

DuckDB Foreign Data Wrapper for PostgreSQL
MIT License
272 stars 18 forks source link

Does duckdb v0.10.2 is supported? #45

Closed AmebaBrain closed 2 months ago

AmebaBrain commented 2 months ago

I've succesfully built docker image for postgres 16.2 with duckdb_fdw and duckdb lib v0.10.2. Mapped duckdb database file with 777 "allow-all" permissions for files and all the directories into the container.

Attempt to read from foreign table or import foreign schema results into postgres server crash

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.

Connect to the same duckdb database file with the same jdbc jar lib version v0.10.2 from DBEaver works fine.

AmebaBrain commented 2 months ago

Closing this as error dissapear if using changes proposed in #38