Thread: Regression in PG14 LookupFuncName

Regression in PG14 LookupFuncName

From
Sven Klemm
Date:
Hi hackers,

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?

Sven

[0] https://github.com/postgres/postgres/commit/e56bce5d



Re: Regression in PG14 LookupFuncName

From
Tom Lane
Date:
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



Re: Regression in PG14 LookupFuncName

From
Sven Klemm
Date:
> 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

Thank you for the clarification.

--
Regards, Sven Klemm