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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lowell Hought <lowell(dot)hought(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17
Date: 2025-06-14 15:15:48
Message-ID: 1628600.1749914148@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Lowell Hought <lowell(dot)hought(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lowell Hought 2025-06-14 15:52:38 Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17
Previous Message Lowell Hought 2025-06-14 14:27:19 Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17