pgsql: Fix pg_event_trigger_ddl_commands for GRANT ON PROPERTY GRAPH

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix pg_event_trigger_ddl_commands for GRANT ON PROPERTY GRAPH
Date: 2026-08-27 09:58:58
Message-ID: E1wzWsr-00000002KBx-2bEn@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix pg_event_trigger_ddl_commands for GRANT ON PROPERTY GRAPH

stringify_grant_objtype() treated OBJECT_PROPGRAPH as unused, so
pg_event_trigger_ddl_commands() failed with "unsupported object type"
when a ddl_command_end trigger inspected GRANT/REVOKE on a property
graph. Return "PROPERTY GRAPH" like the GRANT command syntax.

Bug: #19637
Reported-by: Alexander Lakhin <exclusion(at)gmail(dot)com>
Author: Andrey Rachitskiy <pl0h0yp1(at)gmail(dot)com>
Reviewed-by: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/19637-4446f72945492ed8%40postgresql.org

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/63f8e9773aadba37661f70629a0a0e8f5933afc8

Modified Files
--------------
src/backend/commands/event_trigger.c | 3 ++-
src/test/regress/expected/event_trigger.out | 21 ++++++++++++++++-----
src/test/regress/sql/event_trigger.sql | 11 ++++++++---
3 files changed, 26 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2026-08-27 12:06:35 pgsql: Don't create a shell type for function returning an array
Previous Message Peter Eisentraut 2026-08-27 09:03:36 pgsql: Fix inferred property graph keys with INCLUDE columns