[PATCH] btree_gist: add cross-type integer operator support for GiST

The patch adds cross-type integer operator support for GiST in btree_gist. Alexander Nestorov reports that recent upstream commits broke the patchset's CI: specifically, the signa…

Read Discussion

Don't use the deprecated and insecure PQcancel in our frontend tools anymore

The discussion continues work on replacing the deprecated and insecure PQcancel API in PostgreSQL frontend tools. Jelte Fennema-Nio's patch 0001 removes the redundant `cancel_pres…

Read Discussion

SECURITY LABEL ON PROPERTY GRAPH: supported?

Commit 2f094e7 updated the `security_label.sgml` documentation to indicate that `SECURITY LABEL ON PROPERTY GRAPH` is supported, but attempting the command actually produces an er…

Read Discussion

SQL/JSON json_table plan clause

The thread discusses ongoing development of the SQL/JSON `json_table` PLAN clause patch. Nikita Malakhov submitted v23 addressing earlier review comments from Alexander Korotkov a…

Read Discussion

Make \d tablename fast again, regression introduced by 85b7efa1cdd

A regression introduced by commit 85b7efa1cdd causes `\d tablename` in psql to perform a sequential scan instead of an index scan, degrading performance. Andres Freund originally…

Read Discussion

explain plans for foreign servers

A patch adding EXPLAIN plan support for foreign servers is under review. Dinesh Salve reviewed the latest version submitted by Sami, praising the trimmed-down documentation that a…

Read Discussion

PGNexus Daily News

PostgreSQL Hackers Email Discussion Highlights

Social Media Updates