Horton

Re: Second RewriteQuery complains about first RewriteQuery in edge case

Bernice Southey <bernice.southey@gmail.com>

View thread
From: Bernice Southey <bernice.southey@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, Kirill Reshke <reshkekirill@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-11-26T20:28:33Z
Lists: pgsql-hackers 
Bernice Southey <bernice.southey@gmail.com> wrote:
> I went through the history and it seemed to me the repeat rewrite was
> accidental because of the two ways this method can recurse.
I mean the repeat rewrite of the cteList was accidental, not the
repeat rewrite of views. I couldn't think why a view would mean a
cteList needed re-rewriting, but I know very little about view rules.