Horton

Fix properties orphaned by dropping a label

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 45d4c917ff4f4fe206ad18d0279a47c9f2a08123
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2026-07-05T11:48:32Z
Releases: 19 (unreleased) 
Fix properties orphaned by dropping a label

AlterPropGraph() cleans up pg_propgraph_property entries that are
orphaned by dropping an element or by dropping properties associated
with an element.  But it did not clean up pg_propgraph_property
entries that are orphaned by dropping labels associated with an
element.  Fix this missing case.

Author: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Author: zengman <zengman@halodbtech.com>
Discussion: https://www.postgresql.org/message-id/flat/tencent_76F6ACA2364EAA1E5DBD7A47%40qq.com

Files

PathChange+/−
src/backend/commands/propgraphcmds.c modified +1 −1
src/test/regress/expected/create_property_graph.out modified +11 −12
src/test/regress/sql/create_property_graph.sql modified +5 −0

Discussion