Error creating materialized view

From: Shaun Robinson <srobinson(at)mdxperience(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Error creating materialized view
Date: 2024-11-25 06:08:16
Message-ID: CAMJoR-Zv-otrJE4Wejs9us5x3gf-LBMfL0XT4UfZym-abx-j8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shashidhar Reddy 2024-11-25 06:30:55 Unique key constraint Issue
Previous Message jayesh thakare 2024-11-25 05:39:39 Pg_basebackup failed or completed?