Re: Error creating materialized view

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