Обсуждение: Regression in PG14 LookupFuncName

Поиск
Список
Период
Сортировка

Regression in PG14 LookupFuncName

От
Sven Klemm
Дата:
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

От
Tom Lane
Дата:
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

От
Sven Klemm
Дата:
> 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