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

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
Cc: Vik Fearing <vik@postgresfriends.org>
Cc: Kamil Monicz <kamil@monicz.dev>
Cc: pgsql-bugs@lists.postgresql.org, Peter Eisentraut <peter@eisentraut.org>
Subject: Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18
Date: Tue, 18 Nov 2025 12:59:34 -0500
Message-ID: <1302816.1763488774@sss.pgh.pa.us> (raw)
In-Reply-To: <3215004.1763142948@sss.pgh.pa.us>
References: <19106-9dd3668a0734cd72@postgresql.org>
	<1650412.1762703636@sss.pgh.pa.us>
	<b23b48b7-0222-4b5e-a986-1d79920a7298@app.fastmail.com>
	<1886977.1762794560@sss.pgh.pa.us>
	<1980046.1762808758@sss.pgh.pa.us>
	<36c1f631-f65f-4bb8-90af-9fafdb683547@postgresfriends.org>
	<2184532.1762874669@sss.pgh.pa.us>
	<f2171b06-8970-4946-9092-72b4668c58e4@postgresfriends.org>
	<2226630.1762892879@sss.pgh.pa.us>
	<CAMbWs48G6Fk+5YOhz-4u0+R1+sQZhC_bVTZBY7cqbG6wFWcKDA@mail.gmail.com>
	<2394348.1762975973@sss.pgh.pa.us>
	<CAMbWs498fBh_p+kXRv=-3d8C7TXanjLP_d6RTP3dOXKp+59-rA@mail.gmail.com>
	<3215004.1763142948@sss.pgh.pa.us>

I wrote:
> The more I think about this, the more I like the other idea of just
> throwing an error rather than trying to fix up cases like bug #19055.
> I don't think we have much evidence that anyone is trying to do that
> in the real world (otherwise reports would have surfaced years ago).
> And this discussion is making it clear that fixing it up is harder
> than it sounds.

Hearing no further comments, I've pushed the v2 patch that does it
that way, restoring the previous behavior in cases that would not
have failed before #19055.

			regards, tom lane





view thread (15+ messages)

Message-ID: <1302816.1763488774@sss.pgh.pa.us>
Permalink:  ../1302816.1763488774@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1302816.1763488774@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, guofenglinux@gmail.com, vik@postgresfriends.org, kamil@monicz.dev, peter@eisentraut.org
  Subject: Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18
  In-Reply-To: <1302816.1763488774@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