MIME-Version: 1.0
References: <CAMJoR-Zv-otrJE4Wejs9us5x3gf-LBMfL0XT4UfZym-abx-j8w@mail.gmail.com>
In-Reply-To: <CAMJoR-Zv-otrJE4Wejs9us5x3gf-LBMfL0XT4UfZym-abx-j8w@mail.gmail.com>
From: David Mullineux <dmullx@gmail.com>
Date: Mon, 25 Nov 2024 08:58:15 +0000
Message-ID: <CAGsyd8U6PCSbxXEVAiKgidYDAD+s7gE_xRdWN7gFTFk6-aK+ug@mail.gmail.com>
Subject: Re: Error creating materialized view
To: Shaun Robinson <srobinson@mdxperience.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000906dc40627b8ef4f"
Archived-At: <https://www.postgresql.org/message-id/CAGsyd8U6PCSbxXEVAiKgidYDAD%2Bs7gE_xRdWN7gFTFk6-aK%2Bug%40mail.gmail.com>
Precedence: bulk

--000000000000906dc40627b8ef4f
Content-Type: text/plain; charset="UTF-8"

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

--000000000000906dc40627b8ef4f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Mon, 25 Nov 2024, 06:08 Shaun Robinson, &lt;<a href=
=3D"mailto:srobinson@mdxperience.com">srobinson@mdxperience.com</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;b=
order-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi,<div><br></=
div><div>I&#39;m currently testing an application with Postgres 17.2 and am=
 getting an error when creating a=C2=A0materialized view which works in ver=
sion 16 and below. The sql works fine running as a query, but adding the cr=
eate=C2=A0materialized view breaks it.</div><div><br></div><div>The error c=
omes when calling a custom function and the error is that a relation doesn&=
#39;t exist (which it does as it works within the same query when not creat=
ing a view).</div><div><br></div><div>Is this a known issue in the version =
17.2?</div><div><br></div><div>Thanks</div><div>Shau</div></div></blockquot=
e></div></div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div =
dir=3D"auto">Can you please post the DDL statements so we can see?</div><di=
v dir=3D"auto">Thanks</div><div dir=3D"auto"><div class=3D"gmail_quote"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>can you</div></div></bloc=
kquote></div></div><div dir=3D"auto"><div class=3D"gmail_quote"><blockquote=
 class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex">
</blockquote></div></div></div>

--000000000000906dc40627b8ef4f--