Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function
Date
Msg-id CAKFQuwZYB6hqnaWgS3sZkWPDdiZpTpEvVHB3M+3Q=1VrfbR5fg@mail.gmail.com
Whole thread Raw
In response to 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>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function
Next
From: Jeff Davis
Date:
Subject: Re: BUG #17714: Refresh materialized view does not update all date