| From: | David Mullineux <dmullx(at)gmail(dot)com> |
|---|---|
| To: | Shaun Robinson <srobinson(at)mdxperience(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Error creating materialized view |
| Date: | 2024-11-25 08:58:15 |
| Message-ID: | CAGsyd8U6PCSbxXEVAiKgidYDAD+s7gE_xRdWN7gFTFk6-aK+ug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 25 Nov 2024, 06:08 Shaun Robinson, <srobinson(at)mdxperience(dot)com>
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Robinson | 2024-11-25 09:36:09 | Re: Error creating materialized view |
| Previous Message | ajit wangkhem | 2024-11-25 08:57:17 | Re: Unique key constraint Issue |