public inbox for [email protected]  

help / color / mirror / Atom feed

From: Martin Goodson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
Date: Thu, 12 Mar 2026 21:02:59 +0000
Message-ID: <[email protected]> (raw)

I don't know if anyone has seen this, maybe it's a very common error 
I've just never come across before, but I'm encountering the following 
problem:

I've exported some views from a PG14 database and loaded them into a 
brand new PG17 database via a plain text format pg_dump.

No errors were reported during the dump, so no problems creating the 
views reported.

However, attempting to query the views - which are pretty complex, to be 
fair - result in the query erroring immediately with 'ERROR: 
unrecognized node type: 2'

I've tried repeating the load from the pg_dump file, and it still errors 
immediately with the same error message.

I've tried creating a copy of one of the views (extracting the view 
definition with pg_get_viewdef, and wrapping a create view around it) 
... that results in a new view that is created successfully, but which 
still results in an immediate 'ERROR: unrecognized node type: 2' when 
you query the view.

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.

-- 
-- 
Martin Goodson.

"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."


-- 
--
Martin Goodson.

"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox