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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: benoitfontaine(dot)ba(at)gmail(dot)com, PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function
Date: 2022-12-12 16:38:26
Message-ID: CAKFQuwZYB6hqnaWgS3sZkWPDdiZpTpEvVHB3M+3Q=1VrfbR5fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Dec 12, 2022, 09:28 PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17715
> Logged by: Benoît Fontaine
> Email address: benoitfontaine(dot)ba(at)gmail(dot)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.

>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2022-12-12 17:03:23 Re: BUG #17714: Refresh materialized view does not update all date
Previous Message PG Bug reporting form 2022-12-12 15:42:46 BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function