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?