Error creating materialized view - Mailing list pgsql-general

From Shaun Robinson
Subject Error creating materialized view
Date
Msg-id CAMJoR-Zv-otrJE4Wejs9us5x3gf-LBMfL0XT4UfZym-abx-j8w@mail.gmail.com
Whole thread Raw
Responses Re: Error creating materialized view
Re: Error creating materialized view
List pgsql-general
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
Shaun

pgsql-general by date:

Previous
From: jayesh thakare
Date:
Subject: Pg_basebackup failed or completed?
Next
From: shashidhar Reddy
Date:
Subject: Unique key constraint Issue