Jelte Fennema-Nio comments

Results 688 comments of


                                            Jelte Fennema-Nio

pgq interop not fully there - even for raw_query

duckpgq is currently not supported by pg_duckdb. The first problem requires duckpgq to fix this issue: https://github.com/cwida/duckpgq-extension/issues/210 Then you should be able to use `duckdb.query` instead of `duckdb.raw_query`. The second...

can't access pgbouncer database as stats_users when auth_type=hba

I'm assuming the zbx_monitor exists in your pgbouncer database? Does it work if you set auth_user and auth_dbname globally instead of for the `*` database: ``` [databases] * = host=localhost...

Update 0002-enable-md-pg_duckdb.sql

Thanks for the fix, I'll try it out soon.

Second call of pg_reload_conf() after calling any duckdb function crashes the server

Okay, that's obviously not great. I think it could be related to #867

Second call of pg_reload_conf() after calling any duckdb function crashes the server

Could you check if #936 solves it for you?

Second call of pg_reload_conf() after calling any duckdb function crashes the server

Thanks all for the help debugging this. I found the cause and fixed it in https://github.com/duckdb/pg_duckdb/pull/981

Add sqlsmith fuzzy test

Sorry for not responding. I've been trying to focus on getting 1.0 out (which has been going less well than intended). I'll get back to this after I've actually done...

Running a simple query with the timescaledb and pg_duckdb extensions installed causes the server to crash: Segmentation fault.

Can you share a stack trace of the crash?

Pivot error

Sadly that's because PIVOT is a special type of query in DuckDB that's not allowed to be used in DuckDB its `query` function. I think it could be possible to...

Build fails on GCC 8 due to missing -lstdc++fs when using std::filesystem

Sounds like a reasonable fix. If you create a PR I will merge it.