Sven Klemm <sven@timescale.com> writes:
> In PG12 and PG13 LookupFuncName would return procedures as well as
> functions while in PG14 since commit e56bce5d [0] it would disregard
> all procedures
> and not return them as match.
> Is this intended behaviour or an unintended side effect of the refactoring?
It was intentional, because all internal callers of LookupFuncName only
want to see functions. See the last few messages in the referenced
discussion thread:
https://www.postgresql.org/message-id/flat/3742981.1621533210%40sss.pgh.pa.us
You should be able to use LookupFuncWithArgs if you want a different
definition.
regards, tom lane
