Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17

Tom Lane <tgl@sss.pgh.pa.us>

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
Date: 2025-06-08T03:11:11Z
Lists: pgsql-bugs
Lowell Hought <lowell.hought@gmail.com> writes:
> Changing that parameter had no effect on the version 17 instance.  The
> query itself produces results in a matter of a second or so, but the
> function still hangs and does not return.

Darn.  But I'm still pretty sure that the problem is an undesirable
change of plan, and that we don't have enough information to say
more than that.  Any chance you could extract a self-contained
test case?

			regards, tom lane