Re: BUG #19108: Stack overflow duting query parse

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

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Zhidenkov <pensnarik@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, pgsql-bugs@lists.postgresql.org
Date: 2025-11-10T16:02:48Z
Lists: pgsql-bugs
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