Horton

[PATCH] Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids

Joel Jacobson <joel@compiler.org>

View thread View on postgr.es
From: "Joel Jacobson" <joel@compiler.org>
To: pgsql-hackers@lists.postgresql.org, "Alvaro Herrera" <alvherre@alvh.no-ip.org>
Date: 2021-04-23T07:30:47Z
Lists: pgsql-hackers

Attachments

On Fri, Apr 23, 2021, at 08:54, Joel Jacobson wrote:
> pg_describe_object            | event trigger ddl_postgrest
> pg_identify_object            | ("event trigger",,ddl_postgrest,ddl_postgrest)
> pg_identify_object_as_address | ("event trigger",{},{})
> 
> I therefore think the evtname should be added to object_names.

Could it possibly be as simple to fix as the attached patch?
Not sure if the the string constructed by appendStringInfo() also needs to be adjusted.

With the patch, the example above returns:

pg_identify_object_as_address | ("event trigger",{ddl_postgrest},{})

/Joel

Commits

  1. Fix pg_identify_object_as_address() with event triggers