Horton
Menu

Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: Justin Swanhart <greenlion@gmail.com>
Cc: Martin Goodson <kaemaril@googlemail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-03-13T02:00:32Z
Lists: pgsql-general 
On Thu, Mar 12, 2026 at 05:43:00PM -0400, Justin Swanhart wrote:
> 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.

One could argue that this is a bug, but I doubt that anybody is going
to dive in details into that without a self-contained test case.
--
Michael