PostgreSQL PGQ and DDL disputes lead infrastructure news

PostgreSQL core developers raised release readiness concerns over PGQ bugs and debated redesign of DDL helper functions. Parallel threads covered ClickHouse view security fixes, large QEMU property schema series, and further PostgreSQL work on partitions, TOAST, and temporal queries.

PGQ catalog bugs prompt release readiness questions

Core developers reported multiple locking, dependency, and crash bugs in PGQ catalog representation and its pg_dump support. The Release Management Team questioned whether the work is ready for PostgreSQL 19 or 20. Infrastructure maintainers should track the heated exchange because unresolved catalog issues can block feature inclusion and affect dump restore reliability.

Redesign or removal debated for pg_get_*_ddl helpers

Core hackers disputed the design of pg_get_role_ddl and related helpers over dependency ordering, password handling, and duplication with pg_dump logic. Discussion centered on whether a full redesign or removal is required. Tooling authors who generate DDL from live catalogs need the outcome to keep extraction correct and secure.

ClickHouse closes security gaps in DEFINER views

A ClickHouse thread detailed fixes for security barriers on DEFINER and NONE views. The changes block additional_table_filters and row-policy predicate pushdown from bypassing intended controls. Operators running multi-tenant or row-secured deployments should note the hardening because it closes practical privilege escalation paths.

QEMU series ties QOM properties to QAPI schema types

A 62-patch QEMU series associates QOM and qdev properties with QAPI schema types, replacing ad-hoc strings. The change improves introspection across the device model. Virtualization developers benefit from stronger typing and discoverability in core infrastructure.

Patches address crashes after interrupted partition detach

Developers submitted bug reports and patches for crashes that occur when DETACH PARTITION CONCURRENTLY is interrupted. The work also covers a PostgreSQL 19 regression in publication handling. Production users of concurrent partitioning need the fixes to avoid catalog corruption and query failures.

Earlier QEMU iteration on the same QOM/QAPI work

A preceding 75-patch series pursued the same goal of linking QOM and qdev properties to QAPI schema types for better introspection. It touched many core files and drew broader review. The volume of changes signals how foundational the property model is to ongoing QEMU maintenance.

Review continues for 8-byte TOAST pointer support

Hackers actively reviewed patches that add 8-byte TOAST pointers and Oid8 support via a new reloption. Iterations labeled v16 and v17 received detailed feedback. Larger external storage and future-proofing of toastable types depend on this expansion once accepted.

FOR PORTION OF review flags concurrency and trigger bugs

Andres Freund reviewed the FOR PORTION OF patch set and identified concurrency bugs under READ COMMITTED along with trigger and DELETE problems. The findings affect correctness of temporal range operations. Implementers of portion-based DML must resolve these issues before the feature can be considered stable.