Re: remove_useless_joins vs. bug #19560

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Richard Guo <guofenglinux(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Jacob Brazeal <jacob(dot)brazeal(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, underdog(at)theori(dot)io
Subject: Re: remove_useless_joins vs. bug #19560
Date: 2026-09-26 19:27:52
Message-ID: 138752.1790450872@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> Right. I think the appropriate fix is probably to require
> that the checkAsUser values match in RTEs we want to combine.
> If we do that, I'm not sure that we need to consider securityQuals
> as such (but I've not tried it so maybe I'm missing something).

Concretely, about like this. This fixes the given reproducer.
I've not put thought into what sort of test cases we might want
to add.

regards, tom lane

Attachment Content-Type Size
sje-must-compare-user-ids-too.patch text/x-diff 3.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Manu 2026-09-26 19:25:18 Re: ZSTD TOAST compression, and an extensible compression method encoding