postgres=# create extension duckdb_fdw;
CREATE EXTENSION
postgres=# CREATE SERVER duckdb_server
postgres-# FOREIGN DATA WRAPPER duckdb_fdw
postgres-# OPTIONS (
postgres(# database '/tmp/duck.db'
postgres(# );
CREATE SERVER
postgres=# CREATE FOREIGN TABLE t1 (
postgres(# a integer,
postgres(# b text
postgres(# )
postgres-# SERVER duckdb_server
postgres-# OPTIONS (
postgres(# table 't1_duckdb'
postgres(# );
CREATE FOREIGN TABLE
postgres=# select * from t1;
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.
postgres=# \errverbose
There is no previous error.
postgres=# insert into t1 values (1,'a');
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.
!?> ^C
!?> \q
[postgres@build-el8 tmp]$ psql -E
psql (16.3)
Type "help" for help.
postgres=# \errverbose
There is no previous error.
postgres=# select * from t1;
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.
!?> \errverbose
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.