MIME-Version: 1.0
References: <d1c8f728-6573-4e79-b7bf-aabba0f53ccd@googlemail.com>
In-Reply-To: <d1c8f728-6573-4e79-b7bf-aabba0f53ccd@googlemail.com>
From: Justin Swanhart <greenlion@gmail.com>
Date: Thu, 12 Mar 2026 17:43:00 -0400
Message-ID: <CAJM9iN1t5bf+4Rx0Q3K3hOpNshFTc0Tdma0V4g20d-gF2vHBLA@mail.gmail.com>
Subject: Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node
 type: 2'
To: Martin Goodson <kaemaril@googlemail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bdaef0064cdaa344"
Archived-At: <https://www.postgresql.org/message-id/CAJM9iN1t5bf%2B4Rx0Q3K3hOpNshFTc0Tdma0V4g20d-gF2vHBLA%40mail.gmail.com>
Precedence: bulk

--000000000000bdaef0064cdaa344
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Mar 12, 2026 at 5:03=E2=80=AFPM Martin Goodson <kaemaril@googlemail=
.com>
wrote:

> Unfortunately I cannot provide the view definition due to
> confidentiality agreements =F0=9F=99=81
>
> Any suggestions to what might be the underlying cause for this? Has this
> happened anywhere else? Is there some manner of issue with complexity in
> views in PG17?
>
> Any suggestions, or further information, would be very gratefully
> received =F0=9F=99=82
>
> Thank you.
>
>
See some debugging suggestions on this topic from earlier discussions in
the list:
https://www.postgresql.org/message-id/42a5f581-0482-0c3f-f36e-04c90e6358cb%=
40enterprisedb.com


The other suggestion would be to simplify the view as much as possible
until the problem goes away.  Then you'll know what the problem is.

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Mar 12,=
 2026 at 5:03=E2=80=AFPM Martin Goodson &lt;<a href=3D"mailto:kaemaril@goog=
lemail.com">kaemaril@googlemail.com</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex">Unfortunately I cannot provide the view =
definition due to <br>
confidentiality agreements =F0=9F=99=81<br>
<br>
Any suggestions to what might be the underlying cause for this? Has this <b=
r>
happened anywhere else? Is there some manner of issue with complexity in <b=
r>
views in PG17?<br>
<br>
Any suggestions, or further information, would be very gratefully <br>
received =F0=9F=99=82<br>
<br>
Thank you.<br><br></blockquote><div><br></div><div>See some debugging sugge=
stions on this topic from earlier discussions in the list:=C2=A0<br><a href=
=3D"https://www.postgresql.org/message-id/42a5f581-0482-0c3f-f36e-04c90e635=
8cb%40enterprisedb.com">https://www.postgresql.org/message-id/42a5f581-0482=
-0c3f-f36e-04c90e6358cb%40enterprisedb.com</a>=C2=A0<br><br>The other sugge=
stion would be to simplify the view as much as possible until the problem g=
oes away.=C2=A0 Then you&#39;ll know what the problem is.</div></div></div>

--000000000000bdaef0064cdaa344--