Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids

On Thu, Apr 22, 2021, at 19:32, Alvaro Herrera wrote:
> On 2021-Apr-22, Joel Jacobson wrote:
>
> > Is $SUBJECT intentional, or would it be desirable to add support it?
> >
> > Example:
> >
> > SELECT * FROM pg_catalog.pg_event_trigger;
> > oid | evtname | evtevent | evtowner | evtfoid | evtenabled | evttags
> > -----------+---------------+-----------------+----------+-----------+------------+---------
> > 289361636 | ddl_postgrest | ddl_command_end | 16696 | 289361635 | O |
> > (1 row)
> >
> > SELECT * FROM pg_identify_object_as_address('pg_event_trigger'::regclass,289361636,0);
> > ERROR: requested object address for unsupported object class 32: text result "ddl_postgrest"
>
> Hmm, I think this is an accidental omission and it should be supported.

I've added the patch to the commitfest and added you as a reviewer, hope that works.

/Joel