Re: Error creating materialized view

[David Mullineux <dmullx@xxxxxxxxx>]

On Mon, 25 Nov 2024, 06:08 Shaun Robinson, <srobinson@xxxxxxxxxxxxxxx> 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