Naisila Puka
Naisila Puka
DESCRIPTION: Adds pg15 support Helpful small PRs to main branch: - https://github.com/citusdata/citus/pull/6143 - https://github.com/citusdata/citus/pull/6147 - https://github.com/citusdata/citus/pull/6145 - https://github.com/citusdata/citus/pull/6144 - https://github.com/citusdata/citus/pull/6142 - https://github.com/citusdata/citus/pull/6136 - https://github.com/citusdata/citus/pull/6118 - https://github.com/citusdata/citus/pull/6139 - https://github.com/citusdata/citus/pull/6110
PG15 added support for security invoker views. Relevant PG conmit: https://github.com/postgres/postgres/commit/7faa5fc84bf46ea6c543993cffb8be64dff60d25 These views check the permissions for the underlying tables of the view invoker user, not the view definer user....
### Problem Hitting `cannot handle complex subqueries when the router executor is disabled` error when the router executor is enabled ### Steps to reproduce: ```SQL CREATE TABLE table_1 (id int,...
I am documenting here some flaky tests I have ran into the past weeks, but none of them have extra investigation. - [ ] `subquery_in_where` needs order by https://github.com/citusdata/citus/actions/runs/19567084981/attempts/1#summary-56032048177 ```diff...
Setup: ```SQL CREATE TABLE agg_test(country text, city text); SELECT create_distributed_table('agg_test', 'country', shard_count := 2); INSERT INTO agg_test VALUES ('Albania', 'Tirana'), ('Albania', 'Shkodra'), ('Albania', 'Elbasan'); INSERT INTO agg_test VALUES ('Turkey', 'Ankara'),...
To present pg_stat_io from all the nodes in a distributed Citus cluster, we can add a UDF like the following query in the 12.1 blog post https://www.citusdata.com/blog/2023/09/22/adding-postgres-16-support-to-citus-12-1/#pg-stat-io ```sql WITH workers_stat_io...
PG17 compatibility - Part 1 This PR provides successful compilation against PG17Beta2. Notes to reviewer: - Review commit by commit - it's much cleaner that way. - When merged, [Enable...
Compilation PR: #7651 Fixes #7653 ... under construction