2026-05-04 PostgreSQL News Digest

Commits

There were 9 commits today, covering a broad range of fixes with a particular focus on improving consistency in the SQL/PGQ (Property Graph Query) implementation, along with i18n and documentation cleanup.

⭐ Add handling for nodes appearing in GraphPattern expression trees

Peter Eisentraut — Discussion: CA+3i_M9...

This fixes an "unrecognized node type" error that could occur when GRAPH_TABLE appeared in an expression tree because expression_tree_mutator_impl() did not handle the T_GraphPattern, T_GraphElementPattern, and T_GraphPropertyRef node types. The walker side already handled these nodes, so equivalent mutator handling was added, and missing nodes were also filled in for raw_expression_tree_walker() and expression_tree_walker().

⭐ Do not create a type definition for property graphs

Peter Eisentraut — Discussion: CAHg+QDc...

Property graphs are registered in pg_class, but because they are not tables that store rows, they do not need type definitions. This patch, authored by Ashutosh Bapat and merged after mailing list discussion, avoids unnecessary type creation.

⭐ Fix off-by-one bug in repack index loop

Álvaro Herrera — Discussion: CAExHW5u...

This fixes an off-by-one error in the repack index loop introduced by Álvaro Herrera's own mistake in commit 28d534e2ae0a. After a report from Lakshmi N, Xiaopeng Wang and John Naylor reviewed the fix before commit; the bug could have referenced the wrong range during index reorganization.

⭐ Clean up translatable messages in conflict.c

Amit Kapila — Discussion: CAApHDvo...

append_tuple_value_detail() had treated punctuation such as ": ", ", ", and "." as separate translatable strings, making correct translation impossible in some languages. The code was refactored so callers receive tuple data through a %s placeholder in one translatable string, significantly improving i18n support in multilingual environments (patch by vignesh C, report by David Rowley).

Declare the return type of load_hosts() correctly

Tom Lane

This fixes load_hosts(), which was declared as returning int even though it actually returns the HostsFileLoadResult enum. The typedef was moved to a header file so typedef collection tooling can recognize the type definition as used.

Stabilize tests by adding ORDER BY to test queries

Peter Eisentraut

As a follow-up to commit dc9e7c9ed93, this small fix adds ORDER BY clauses to eliminate flaky tests caused by nondeterministic result ordering.

Fix display order for the pg_restore --no-globals option

Peter Eisentraut

The --no-globals option added in commit 3c19983cc08 had appeared out of order in the documentation and help output. This commit fixes the ordering.

Add serial comma

Peter Eisentraut

This is a small documentation wording fix that adds missing Oxford commas in English text.

Fix spacing around verbatim DocBook elements in documentation

Peter Eisentraut

This formatting cleanup standardizes spacing around DocBook verbatim elements such as <literal>, improving rendered documentation quality.

HN News

⭐ PGKeeper: Figma's Postgres connection pooler Renaissance era

Score: 13 / Comments: 2

This Figma blog post explains the background and design of PGKeeper, a custom connection pooler built to overcome PgBouncer limitations such as connection spikes, failover behavior, and observability challenges. It is a useful real-world example of connection-pooling design for large PostgreSQL operators.

Postgresparser: ANTLR-based PostgreSQL query parser for Go

Score: 3 / Comments: 0

ValkDB released an ANTLR-based PostgreSQL query parser library for Go. It offers an alternative approach to existing libpg_query bindings for query parsing and transformation in Go.

Summary

May 4, 2026 was a day of concentrated fixes around PostgreSQL's SQL/PGQ (Property Graph Query) feature. Work progressed across multiple commits to improve graph query implementation consistency, including mutator support for expression trees containing GRAPH_TABLE and avoiding unnecessary type definitions for property graphs. The conflict.c i18n improvement and Figma's technical write-up on PGKeeper also stood out.

This digest was generated by Claude based on Hacker News, GitHub, and the PostgreSQL mailing list.