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.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1uQTUW-00Bhf6-6e
	for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Jun 2025 16:12:24 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1uQTUT-009JEu-LV
	for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Jun 2025 16:12:22 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1uQTUT-009JEg-D1
	for pgsql-bugs@lists.postgresql.org; Sat, 14 Jun 2025 16:12:22 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1uQTUS-001z2A-1N
	for pgsql-bugs@lists.postgresql.org;
	Sat, 14 Jun 2025 16:12:21 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 55EGCHiO1634856;
	Sat, 14 Jun 2025 12:12:18 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lowell Hought <lowell.hought@gmail.com>
cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18950: pgsql function that worked in Postgresql 16 does not
 return in Postgresql 17
In-reply-to: 
 <CAJtAGPriJrVYmWKyPaMhmHCnLqA4Rs7tv2=r_zZ2sTpg_Z-ZNw@mail.gmail.com>
References: <e9eb5136fb60188fc61c110e9706709fc13638e0.camel@cybertec.at>
 <75D714EA-CD1E-4F80-A2E8-29E378EC2200@gmail.com>
 <81946.1749348479@sss.pgh.pa.us>
 <CAJtAGPpa4yYS6LLO5RHzwe9q7NpHiuuvEX1wVtErpie3EBWZJQ@mail.gmail.com>
 <CAJtAGPrcK_gp8FuEzp4tTbLKD1mqFGY5yDk0FX_1AGDjVJXAuw@mail.gmail.com>
 <CAJtAGPpeqrgKNHdWqr=uPu1_UwN_TAgUvN4cfcWOaRN8U+8zDA@mail.gmail.com>
 <89144.1749352271@sss.pgh.pa.us>
 <CAJtAGPpURGxCJRWVeFsPbu2fjtaSCwVsBNZ5_QW0wE5N6Z-N=Q@mail.gmail.com>
 <90964.1749353175@sss.pgh.pa.us>
 <CAJtAGPof_SZ4mWHwv5QJqu43NzmO7EVCW_Rc-EDX8qKemCsyhw@mail.gmail.com>
 <CAJtAGPrmPgyLZfL2TL5oN8iN2yzz0=r98twiHWrWxos0ytmGtA@mail.gmail.com>
 <1628600.1749914148@sss.pgh.pa.us>
 <CAJtAGPriJrVYmWKyPaMhmHCnLqA4Rs7tv2=r_zZ2sTpg_Z-ZNw@mail.gmail.com>
Comments: In-reply-to Lowell Hought <lowell.hought@gmail.com>
	message dated "Sat, 14 Jun 2025 10:52:38 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1634854.1749917537.1@sss.pgh.pa.us>
Date: Sat, 14 Jun 2025 12:12:17 -0400
Message-ID: <1634855.1749917537@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/1634855.1749917537%40sss.pgh.pa.us>
Precedence: bulk

Lowell Hought <lowell.hought@gmail.com> writes:
> Unfortunately, I have not been able to create a script that reproduces the
> issue.  I ran EXPLAIN with a LIMIT clause and again without a LIMIT clause,
> save the output to files and then compared them.  I am not good at
> understanding the EXPLAIN output.

Unfortunately, your email program has mangled the EXPLAIN output to
the point of unreadability, as it's preserved neither line breaks nor
indentation.  Maybe it'd work better to put the output in attachments.

			regards, tom lane