Fix pg_identify_object_as_address() with event triggers
authorMichael Paquier <michael@paquier.xyz>
Wed, 28 Apr 2021 02:18:17 +0000 (11:18 +0900)
committerMichael Paquier <michael@paquier.xyz>
Wed, 28 Apr 2021 02:18:17 +0000 (11:18 +0900)
commitf3c4537876843bea9a9d35d9643d347750961848
tree3de839dd6ee781993abaf27c785b88c43fb28cd2
parentec5bab9217cddfda134abf1131904ec1958caadb
Fix pg_identify_object_as_address() with event triggers

Attempting to use this function with event triggers failed, as, since
its introduction in a676201, this code has never associated an object
name with event triggers.  This addresses the failure by adding the
event trigger name to the set defining its object address.

Note that regression tests are added within event_trigger and not
object_address to avoid issues with concurrent connections in parallel
schedules.

Author: Joel Jacobson
Discussion: https://postgr.es/m/3c905e77-a026-46ae-8835-c3f6cd1d24c8@www.fastmail.com
Backpatch-through: 9.6
src/backend/catalog/objectaddress.c
src/test/regress/expected/event_trigger.out
src/test/regress/sql/event_trigger.sql