Re: Error creating materialized view - Mailing list pgsql-general

From David Mullineux
Subject Re: Error creating materialized view
Date
Msg-id CAGsyd8U6PCSbxXEVAiKgidYDAD+s7gE_xRdWN7gFTFk6-aK+ug@mail.gmail.com
Whole thread Raw
In response to Error creating materialized view  (Shaun Robinson <srobinson@mdxperience.com>)
Responses Re: Error creating materialized view
List pgsql-general


On Mon, 25 Nov 2024, 06:08 Shaun Robinson, <srobinson@mdxperience.com> wrote:
Hi,

I'm currently testing an application with Postgres 17.2 and am getting an error when creating a materialized view which works in version 16 and below. The sql works fine running as a query, but adding the create materialized view breaks it.

The error comes when calling a custom function and the error is that a relation doesn't exist (which it does as it works within the same query when not creating a view).

Is this a known issue in the version 17.2?

Thanks
Shau


Can you please post the DDL statements so we can see?
Thanks
can you

pgsql-general by date:

Previous
From: ajit wangkhem
Date:
Subject: Re: Unique key constraint Issue
Next
From: Shaun Robinson
Date:
Subject: Re: Error creating materialized view