Horton

Fix properties orphaned by dropping a label

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 0e4f0827f63900374ce7352f1f9e4c39363218d0
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2026-07-05T11:51:32Z
Releases: master 
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