Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w0rpV-002HFT-0j for pgsql-general@arkaria.postgresql.org; Fri, 13 Mar 2026 02:00:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0rpQ-001EDF-2C for pgsql-general@arkaria.postgresql.org; Fri, 13 Mar 2026 02:00:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w0rpQ-001ED7-1B for pgsql-general@lists.postgresql.org; Fri, 13 Mar 2026 02:00:40 +0000 Received: from fout-a4-smtp.messagingengine.com ([103.168.172.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w0rpO-00000002OIz-2FUo for pgsql-general@lists.postgresql.org; Fri, 13 Mar 2026 02:00:40 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfout.phl.internal (Postfix) with ESMTP id D3B17EC0B79; Thu, 12 Mar 2026 22:00:37 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Thu, 12 Mar 2026 22:00:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1773367237; x=1773453637; bh=UA7vY7H9G5 4LlRGjZI/vlJNc6OP0FuLX+MlCnMfJJc8=; b=oLJp2t6y9ZoXgU4DAzprex7rhZ qmftBoS7JabWtpUyA7IMI15Mtce6wG8Ka59RKUn5LkpOPPbeNFnrPvkRtAZnvy5Z ppQc1OGR3G7unxgtYvXAQtvY5z8WC40lLfDoqVKqBAw77rgN6QUkymM/VeSNjLbX JeGEjIYcPm+eVfZHZHQOVKFcwZxZvo60MJvaqCojMyg4E/VE6+IcNKW65bO5xo69 1+2fDef1MrQht7rTUBSSgE1n/gxZoJEf9frFv/rJaTasOXrtFrRSk0PUd4ABtvHJ dEB0IhXOnaK7xgYiOVbSJne5oMJG+nG1Vu0fjApq1RJ5yXksTyU62hgQfFXA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1773367237; x=1773453637; bh=UA7vY7H9G54LlRGjZI/vlJNc6OP0FuLX+Ml CnMfJJc8=; b=SfOhr4s7sECfnhHhALhMEb27DjJONEOcDLnw63jMMNc5vp4903w t68Ca5WNR/AdY4DlYExFKQLxiaHa/qfrg3jvaEqSdMGl+aEyenB3dYW19eZ4ywym 9oRVZmLuTyQ3Vh9ah6FzDi+K3Tdt9vaY0H9i0KOC2q9Ie0ImQyBHwSRaUX1U5mI+ /wKOQ9n361U6qiro0/2wjf3HAyp6qbBw+7pFXFs0Ir74LEVke+gxCcBySN8l3mVm X51OO7yMii8d08kPsHOIMpBAg8cQPCl9G0I3iDJoECHS1PTtzePK2KWOGBAE1+Xs u9UVIkf/uBS6Z83fi8s+g3Coe7jUf3v/txA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvkeekgedtucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeggeeg fffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidp nhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepghhrvg gvnhhlihhonhesghhmrghilhdrtghomhdprhgtphhtthhopehkrggvmhgrrhhilhesghho ohhglhgvmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslh hishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 12 Mar 2026 22:00:36 -0400 (EDT) Date: Fri, 13 Mar 2026 11:00:32 +0900 From: Michael Paquier To: Justin Swanhart Cc: Martin Goodson , "pgsql-generallists.postgresql.org" Subject: Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="0zgDmJhCdasf3nDi" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0zgDmJhCdasf3nDi Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 --0zgDmJhCdasf3nDi Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmmzb8AACgkQnvQgOdby QH2Ewg/8D1wGoqt2dAIZ8120zw0qeGUXKoWHxca0n0OaoVBB1DPTwBWeFPeZs1w7 TxAWnILVSMHFacB4fwgczsDzEeDBIjZb6ECWg3SxsMgGza/TCkAhkU0ZoCeqj6NZ u6/Nex5Wh8MKZTct9HwykfzC6szy4kt6dxy+U2e3bNaFBXpvR6MJhKUfM3vMplq6 krx+k6rB9pMk4WH5EFlrrLs4w4Aoxm8yHwtrV7oftiNu56QRc/r3WG/d3k1iZ9YB 2nUABNfmBW8J9EV4keWcpOmDaISmSyWn5dCiaI9l6eJSIoTo+8ybvR3ryYPdmdtY 4UFlUd0Yvky/lnuLRo3yD0BoLsmsqQMYSTrtu6zMQQHDKFqrlCv3L77nGN0QZd+6 2nOkvXamUUGVwXpiRd5+Ebn65F7yX/R3WOSN3M1hIotCobahyb8Zrxms2PoftGWU jldgiHV/4S3PD0auOr44rB9NrtQez0K3lVGPNDW8gSpoZWPvFvhhPUiAujO/14qo QdUJXc10Tmz0xM/ygRIkJpZwIgI3fBREMoroGjn2ppyi3ZtK9jpr43WPUG8hygqS +sRzuoXb+CTnIxd9/8pH319UPUHHDL0q0a6bLScahdzuNU9A15jkyYV6dHIvcFUU gKR3j8lCLaCtC73GP29qRZNl6Rej329NEzzky4hYUVarOWUsr50= =aVhu -----END PGP SIGNATURE----- --0zgDmJhCdasf3nDi--