From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Zhidenkov <pensnarik@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19108: Stack overflow duting query parse
Date: Mon, 10 Nov 2025 11:02:48 -0500
Message-ID: <1879801.1762790568@sss.pgh.pa.us> (raw)
In-Reply-To: <CAN=gQ4DQKP+Hb+a57SKE9_g2_Utumfccacc9pnw9Okpr6RwVrQ@mail.gmail.com>
References: <19108-13b9dd7a2d30a9cc@postgresql.org>
<e7c2340a-3a01-4095-b606-0e8e77384084@iki.fi>
<CAN=gQ4DQKP+Hb+a57SKE9_g2_Utumfccacc9pnw9Okpr6RwVrQ@mail.gmail.com>
Andrey Zhidenkov <pensnarik@gmail.com> writes:
>> Can you create a self-contained SQL script to reproduce this, and post it
>> on this thread with reply-all, please?
> Unfortunately, I cannot reproduce the issue even on an existing 15.7
> node (one that hasn't upgraded) (don't know if it matters, but now it's a
> hot standby node) but there are core dumps and debug info packages
> installed so I can provide more data from core dump.
Could you at least provide a not-mangled-to-the-point-of-incorrectness
version of the query? The posted one fails with
ERROR: table name "tablename_v2" specified more than once
and there are other visible bugs in it. Some clarity about the column
data types would be helpful as well.
regards, tom lane
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: tgl@sss.pgh.pa.us, pensnarik@gmail.com, hlinnaka@iki.fi, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19108: Stack overflow duting query parse
In-Reply-To: <1879801.1762790568@sss.pgh.pa.us>
* 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