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

From Joel Jacobson
Subject Re: [PATCH] Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids
Date
Msg-id e04ff1dc-499a-48c3-8f2f-4ba9f28a71cb@www.fastmail.com
Whole thread Raw
In response to Re: [PATCH] Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids  (Michael Paquier <michael@paquier.xyz>)
Responses Re: [PATCH] Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids  (Japin Li <japinli@hotmail.com>)
Re: [PATCH] Re: pg_identify_object_as_address() doesn't support pg_event_trigger oids  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Mon, Apr 26, 2021, at 10:30, Michael Paquier wrote:
On Fri, Apr 23, 2021 at 09:33:36AM +0200, Joel Jacobson wrote:
> Also, since this is a problem also in v13 maybe this should also be
> back-ported?  I think it's a bug since both
> pg_identify_object_as_address() and event triggers exists in v13, so
> the function should work there as well, otherwise users would need
> to do work-arounds for event triggers.  

No objections from here to do something in back-branches.  We cannot
have a test for event triggers in object_address.sql and it would be
better to keep it in a parallel set (see 676858b for example).  Could
you however add a small test for that in event_trigger.sql?  It would
be good to check after all three functions pg_identify_object(),
pg_identify_object_as_address() and pg_get_object_address().
--
Michael

Thanks for the guidance in how to test.

I've added a test at the end of event_trigger.sql,
reusing the three event triggers already in existence,
just before they are dropped.

New patch attached.

/Joel
Attachment

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Replication slot stats misgivings
Next
From: Amul Sul
Date:
Subject: Skip temporary table schema name from explain-verbose output.