Horton

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
Date: 2021-04-22T17:11:25Z
Lists: pgsql-hackers 
Hi,

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"

/Joel

Commits

  1. Fix pg_identify_object_as_address() with event triggers