pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Lowell Hought <lowell.hought@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17
Date: Sat, 7 Jun 2025 20:40:32 -0500
Message-ID: <75D714EA-CD1E-4F80-A2E8-29E378EC2200@gmail.com> (raw)
In-Reply-To: <e9eb5136fb60188fc61c110e9706709fc13638e0.camel@cybertec.at>
References: <e9eb5136fb60188fc61c110e9706709fc13638e0.camel@cybertec.at>

If I run the query outside of the function it works as expected.  But the function never returns.

Lowell

> On Jun 7, 2025, at 7:27 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> 
> On Sat, 2025-06-07 at 16:08 +0000, PG Bug reporting form wrote:
>> PostgreSQL version: 17.5
>> Operating system:   Red Hat Enterprise Linux release 8.10 (Ootpa)
>> 
>> A pgsql function that returns Table is relatively simple.  It accepts two
>> arguments; a date and an interval.  It uses these to arguments in a query
>> that returns a result set.  This function worked in Postgresql 16.1 and
>> Postgresql 16.9.  However, it does not work in versions 17.0 nor in 17.5
>> 
>> [function definition]
>> 
>> This is the first time I have ever encountered a bug and so I have no
>> experience with reporting it.
> 
> Your function essentially is running a query.
> If you run that query outside of the function, does it finish on time?
> If not, you have a simpler problem to tackle.
> 
> It need not necessarily be a bug if some queries perform worse in a later
> PostgreSQL version.  There are too many factors involved in the execution
> of a complicated query.  To give help, we'd need at least the EXPLAIN
> output from the query and the EXPLAIN (ANALYZE, BUFFERS) output from the
> query on the old version.
> 
> Yours,
> Laurenz Albe





view thread (20+ messages)  latest in thread

Message-ID: <75D714EA-CD1E-4F80-A2E8-29E378EC2200@gmail.com>
Permalink:  ../75D714EA-CD1E-4F80-A2E8-29E378EC2200@gmail.com/
Also on:    postgresql.org/message-id/75D714EA-CD1E-4F80-A2E8-29E378EC2200@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: lowell.hought@gmail.com, 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: <75D714EA-CD1E-4F80-A2E8-29E378EC2200@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox