Don't accept length of -1 in pg_locale.h APIs.

Jeff DavisDiscussion: s32n3tm2mjh247f3xkkxkdk7cf77hglbr3ia3hrsdjylajou7y

This commit reverts a previous change that accepted a length of -1 in pg_locale.h APIs, as it interfered with useful tooling and was deemed not worth the special cases.


doc PG 19 relnotes: remove "Add fake LSN support to hash index"

Bruce MomjianDiscussion: CAH2-Wzm1UAuv9ih6_ATbwbmrmusKPoJ2qSo3HBF-JaUEkVYUPg

This commit updates the PostgreSQL 19 release notes by removing an entry about "Add fake LSN support to hash index" and adds a missing commit link to a json_array() item.


Re-add regression tests for ltree and intarray

Michael PaquierDiscussion: agZc6Xec

Regression tests for ltree and intarray, previously removed due to instability with low max_stack_depth values, have been re-added after being reworked for better portability. The tests for findoprnd() overflows now use a balanced tree to manage stack usage.


psql: Fix tab completion for REPACK boolean options

Fujii MasaoDiscussion: CA+fm-RNZpy7MAceR9gSyy833H_uL-fTx0LxO73RnvwEaprpuRA

This commit addresses an issue in psql where tab completion for REPACK's boolean options (ANALYZE, CONCURRENTLY, and VERBOSE) did not suggest ON and OFF values, bringing its behavior in line with VACUUM.


HN News

Show HN: FlyQL: query language to filter data or generate SQL

Score: 3 / Comments: 0

FlyQL is introduced as a query language designed to facilitate data filtering or SQL generation, aiming to provide a flexible way to interact with data.


Summary

Today's PostgreSQL news highlights several key developments. Commits included a revert for pg_locale.h API changes, documentation updates for PG 19 release notes, and the re-introduction of more robust regression tests for ltree and intarray. Additionally, a fix was implemented for psql's tab completion for REPACK boolean options. The Hacker News section featured FlyQL, a new query language for data filtering and SQL generation.


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