From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Joel Jacobson <joel(at)compiler(dot)org> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids |
Date: | 2021-04-22 17:32:48 |
Message-ID: | 20210422173248.GA7605@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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!"
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2021-04-22 17:34:37 | Re: TRUNCATE on foreign table |
Previous Message | Joel Jacobson | 2021-04-22 17:11:25 | pg_identify_object_as_address() doesn't support pg_event_trigger oids |