Re: BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function
Дата
Msg-id CAKFQuwZYB6hqnaWgS3sZkWPDdiZpTpEvVHB3M+3Q=1VrfbR5fg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Mon, Dec 12, 2022, 09:28 PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17715
Logged by:          Benoît Fontaine
Email address:      benoitfontaine.ba@gmail.com
PostgreSQL version: 14.5
Operating system:   debian
Description:       

CREATE FUNCTION myfunc (p integer) RETURNS integer AS $$
BEGIN
    RETURN square(p) + 1;
END;
$$ LANGUAGE plpgsql;

Schema qualify the function call so it can work regardless of the search_path setting.

David J.




В списке pgsql-bugs по дате отправления: