pg_identify_object_as_address() doesn't support pg_event_trigger oids

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: pg_identify_object_as_address() doesn't support pg_event_trigger oids
Date: 2021-04-22 17:11:25
Message-ID: 3c905e77-a026-46ae-8835-c3f6cd1d24c8@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-04-22 17:32:48 Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids
Previous Message Andrew Dunstan 2021-04-22 16:42:33 Re: multi-install PostgresNode fails with older postgres versions