Crash issue in PG18.5 regression

Jeff Davis is addressing several issues with the `pg_strlower()` API in PostgreSQL 18, following feedback from Andres Freund. Fixes include: improving the severely underdocumented…

Read Discussion

Implement waiting for wal lsn replay: reloaded

The discussion covers a patchset (6 patches) implementing fixes and cleanups for WAL LSN replay waiting on standby. Key changes include: fixing missing cleanup when auxiliary proc…

Read Discussion

Row pattern recognition

Tatsuo Ishii reports a bug in the row pattern recognition (RPR) deparser related to view definitions. When a query uses a subquery workaround to resolve ambiguous column reference…

Read Discussion

basebackup: do not verify checksums on pages written before enabling checksums

During a basebackup, pages written before checksums were enabled should not have their checksums verified. Zsolt Parragi submitted a patch; Daniel Gustafsson and Bertrand Drouvot…

Read Discussion

GIN VACUUM can corrupt internal posting tree pages

Peter Geoghegan reports a GIN index corruption bug affecting all stable PostgreSQL branches, originally flagged by Opus 5. The issue is in `ginVacuumPostingTreeLeaves()`: after a…

Read Discussion

Disallow outer-level and WHERE-clause aggregates in GRAPH_TABLE

Tom Lane reviewed Sami Imseih's v3 patch for disallowing outer-level and WHERE-clause aggregates in GRAPH_TABLE. While the general pattern of adding EXPR_KIND values was acceptabl…

Read Discussion

PGNexus Daily News

PostgreSQL Hackers Email Discussion Highlights

Social Media Updates