pgsql: Handle element label and label property objects in object addres

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Handle element label and label property objects in object addres
Date: 2026-06-05 07:08:51
Message-ID: E1wVOfj-0019QN-2I@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Handle element label and label property objects in object address functions

getObjectTypeDescription() and getObjectIdentityParts() do not handle
objects in pg_propgraph_element_label and pg_propgraph_label_property
catalogs. These functions when called for handling DDL that affects
these objects cause an "unsupported object class" error. An error is
reported when these functions are called via pg_identify_object() and
pg_identify_object_as_address() with objects from the said catalogs.

The objects in these catalogs do not have a (user-given) name but they
can be manipulated individually through ALTER PROPERTY GRAPH
sub-commands. Hence they need to be accessible to the event triggers.
Handle these catalogs in the respective functions.

Reported-by: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Author: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
Author: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Reviewed-by: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/aej1DkLwhyZWmtxJ@bdtpg

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/72498a86989e3491228ba09be43eab778a3ac943

Modified Files
--------------
src/backend/catalog/objectaddress.c | 89 ++++++++++
.../regress/expected/create_property_graph.out | 189 ++++++++++++---------
src/test/regress/expected/event_trigger.out | 22 +++
src/test/regress/expected/object_address.out | 9 +-
src/test/regress/sql/create_property_graph.sql | 31 ++--
src/test/regress/sql/event_trigger.sql | 15 ++
src/test/regress/sql/object_address.sql | 5 +-
7 files changed, 267 insertions(+), 93 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2026-06-05 07:35:18 pgsql: Fix LATERAL references in GRAPH_TABLE with multi-label pattern
Previous Message Alexander Korotkov 2026-06-05 05:47:51 Re: pgsql: pg_dump: scope indAttNames per index in getIndexes()