Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids
Date
Msg-id 20210422173248.GA7605@alvherre.pgsql
Whole thread Raw
In response to pg_identify_object_as_address() doesn't support pg_event_trigger oids  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids  ("Joel Jacobson" <joel@compiler.org>)
Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
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.

-- 
Álvaro Herrera                            39°49'30"S 73°17'W
"In Europe they call me Niklaus Wirth; in the US they call me Nickel's worth.
 That's because in Europe they call me by name, and in the US by value!"



pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: pg_identify_object_as_address() doesn't support pg_event_trigger oids
Next
From: Justin Pryzby
Date:
Subject: Re: pgsql: autovacuum: handle analyze for partitioned tables