pgsql: Fix inferred property graph keys with INCLUDE columns

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix inferred property graph keys with INCLUDE columns
Date: 2026-08-27 09:03:36
Message-ID: E1wzW1H-00000002JsX-1KQV@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix inferred property graph keys with INCLUDE columns

Inferred property graph keys used all attributes stored in the primary
key index, causing non-key INCLUDE columns to become part of the graph
key. Use only the index's key attributes.

Author: Muhammad Taha Naveed <m(dot)taha(dot)naveed27(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAPTqav%2BVUjYgm1jZy0Scy%3D1-PfdgznVj2%3DPwH8disiXF76HEow%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8646d1d5904503f7e8cbb7166e857fed63c6e49c

Modified Files
--------------
src/backend/commands/propgraphcmds.c | 3 ++-
src/test/regress/expected/create_property_graph.out | 3 ++-
src/test/regress/sql/create_property_graph.sql | 3 ++-
3 files changed, 6 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2026-08-27 09:58:58 pgsql: Fix pg_event_trigger_ddl_commands for GRANT ON PROPERTY GRAPH
Previous Message Alexander Korotkov 2026-08-27 08:14:55 pgsql: Revert support for ALTER TABLE ... MERGE/SPLIT PARTITION(S) comm