Horton
Menu

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

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

View thread
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-14T15:15:48Z
Lists: pgsql-bugs 
Lowell Hought <lowell.hought@gmail.com> writes:
> Why would it return with a LIMIT clause, but not without the LIMIT clause?

[ shrug... ]  I still suppose this is due to a poor choice of plan
in the no-LIMIT case, but you've yet to provide the info needed
for someone else to reproduce the problem.  You could try comparing
EXPLAIN output in the LIMIT and no-LIMIT cases.

			regards, tom lane