Request a Demo
Home   >   mailing lists

Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' - Mailing list pgsql-general

From Justin Swanhart
Subject Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
Date
Msg-id CAJM9iN1t5bf+4Rx0Q3K3hOpNshFTc0Tdma0V4g20d-gF2vHBLA@mail.gmail.com
Whole thread Raw
In response to (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'  (Martin Goodson <kaemaril@googlemail.com>)
Responses Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
List pgsql-general
Tree view


On Thu, Mar 12, 2026 at 5:03 PM Martin Goodson <kaemaril@googlemail.com> wrote:
Unfortunately I cannot provide the view definition due to
confidentiality agreements 🙁

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 🙂

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.

pgsql-general by date:

Previous
From: Martin Goodson
Date:
Subject: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
Next
From: Igor Korot
Date:
Subject: libq API question