Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18
Date
Msg-id 1302816.1763488774@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #19106: Potential regression with CTE materialization planning in Postgres 18  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: BUG #19117: postgresql15-contrib-15.15 for RHEL 9 has conflicting OpenSSL dependencies (3.0.0 and 3.4.0)
Next
From: Devrim Gündüz
Date:
Subject: Re: BUG #19113: Missing updated libpq5 rpm in repo pgdg-common after minor release to 18.1