Mehmet YILMAZ

Add FREEZE Option to COPY Command and Explicit Transaction Management for Shard Moves

2

Here's a suggested description for your PR based on the issue: --- ### Description This PR enhances shard moves and splits by adding the `FREEZE` option to the `COPY` command,...

Pg18 ruleutils adaptation

1

https://github.com/postgres/postgres/commits/master/src/backend/utils/adt/ruleutils.c

Support PostgreSQL 18’s new RTE kinds in Citus deparser to fix OID 0 and “*GROUP*” errors

1

Fixes #8020 PostgreSQL 18 introduces two new, *pseudo* rangetable‐entry kinds that Citus’ downstream deparser must recognize: 1. **Pulled-up shard RTE clones** (`CITUS_RTE_SHARD` with `relid == InvalidOid`) 2. **Grouping-step RTE** (`RTE_GROUP`,...

**Reproduce** ``` SET citus.next_shard_id TO 1640000; CREATE SCHEMA ch_bench_having; SET search_path = ch_bench_having, public; CREATE TABLE stock ( s_w_id int NOT NULL, s_i_id int NOT NULL, s_order_cnt int NOT NULL);...

PG18 Support - Regression tests sanity

4

Latest diffs with PG18.0 (Nov-17): https://github.com/citusdata/citus/actions/runs/19422731228

PG18 – check-split - Columnar write fails with “invalid logical offset: 0” on INSERT/COPY

1

``` diff -dU10 -w /__w/citus/citus/src/test/regress/expected/citus_split_shard_columnar_partitioned.out /__w/citus/citus/src/test/regress/results/citus_split_shard_columnar_partitioned.out --- /__w/citus/citus/src/test/regress/expected/citus_split_shard_columnar_partitioned.out.modified 2025-06-13 14:36:06.794940240 +0000 +++ /__w/citus/citus/src/test/regress/results/citus_split_shard_columnar_partitioned.out.modified 2025-06-13 14:36:06.816940361 +0000 @@ -133,46 +133,48 @@ ALTER TABLE sensors_2020_01_01 ADD CONSTRAINT fkey_from_child_to_ref FOREIGN KEY (measureid) REFERENCES...

PG18 Support

1

DESCRIPTION: PR description that will go into the change log, up to 78 characters

PostgreSQL 18 — What matters for Citus

2

## 1 · Extension packaging & control‑file handling | What changed | Why it matters for Citus | | ----------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | **`extension_control_path` GUC** — lets the server...