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

From: Lowell Hought <lowell(dot)hought(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 21:35:20
Message-ID: CAJtAGPrZwQZW5idX6p_y7Fm+37TxBg=HkBcGQhCt6MjvTXmnkw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Attached in three separate files.

On Sat, Jun 14, 2025 at 11:12 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

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

Attachment Content-Type Size
Explain with limit.sql application/octet-stream 11.4 KB
Explain without limit.sql application/octet-stream 11.3 KB
Explain with limit diff.sql application/octet-stream 2.2 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-06-14 22:26:37 Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17
Previous Message Tom Lane 2025-06-14 16:12:17 Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17