pg_duckdb

pg_duckdb copied to clipboard

Support local parquet, iceberg, etc files

1

It would be nice to be able to read local data files, not just those in cloud storage This would be useful in air gapped and other high security/constrained environments

wearpants

Resource leak on error, eventual crash on out of memory

2

If an error happens during execution, some resources are leaked. If you keep doing that for long enough, the server crashes: ``` $ psql postgres -c "create table foo as...

hlinnaka

Error with extended query protocol

2

``` postgres=# create table tbl(i int4); CREATE TABLE postgres=# select * from tbl \bind \g ERROR: unrecognized node type: 1189775888 ``` See https://github.com/duckdb/pg_duckdb/blob/177b12b7a39fc14e9c0ffb136c8c9c957dc3f2d7/src/pgduckdb_planner.cpp#L91 The problem is that the type stored...

hlinnaka

Use separated libduckdb.so rpm / deb

3

How about using a separate libduckdb.so in /usr/lib64/ instead of an embedded one? `libduckdb.so` is independent of the PostgreSQL major version. If you plan to install `pg_duckdb_16` and `pg_duckdb_17` (in...

Vonng

Case insensitivity mismatch between duckdb and postgres can cause issues

2

DuckDB considers identifiers with different casing the same even if they are quoted. The most minimal example of this is the following schema: ``` CREATE TABLE a(b int); CREATE TABLE...

JelteF

Add the `PostgresStorageExtension` to DuckDB

4

This PR aims to implement #56 It is still very barebones, a lot of the API's virtual methods are not implemented, but all existing tests are passing[1]. The existing functionality...

Tishj

Misleading error when using `read_xxx` functions with invalid URLs

1

I get ```ERROR: Function `read_csv(TEXT)` only works with Duckdb execution.``` when using `read_csv` (along with the actual error as a warning): ``` y=# SELECT * from read_csv('https://www.data.gouv.fr/fr/datasets/r/6d186965-f41b-41f3-9b23-88241cc6890c') as (n int);...

Y--

This is a basic POC to support creating tables in DuckDB. There's a bunch of (important) TODO's in the code but at least this is a start.

JelteF

Support for table index

1

If there exists index on table - research and explore possibility that they can be used for scan. Interesting would be to look into BRIN indexes that can be used...

mkaruza

Harden against Postgres interactions with C++ destructors

2

While looking at the the C++ guidelines in the CONTRIBUTING.md file proposed in #90, I realized/remembered that Postgres C and regular C++ are not automatically the good friends that the...

JelteF