Re: Fix bug with accessing to temporary tables of other sessions

From: Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com>
To: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Cc: Daniil Davydov <3danissimo(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stepan Neretin <slpmcf(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fix bug with accessing to temporary tables of other sessions
Date: 2026-04-16 06:41:53
Message-ID: CAMtXxw_2VnP5U7U+2ObOCC2voEkAzUqAgH=rPTQBXrb_8K=pyA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Thank you for the guidance and the updated patch.

On Mon, Apr 13, 2026 at 7:26 PM Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> wrote:
>
> Hi
>
> On 13/04/2026 14:40, Soumya S Murali wrote:
> > Please let me know if there are additional scenarios I should
> > validate. Looking forward to more feedback.
>
> Thanks for testing it. You can take a look at
> 012_temp_obj_multisession.pl and check if we missed any path.
>
> Due to changes introduced in b2a17ba7a5d the patch was no longer
> applying. See rebased v18 attached.
>

I tested the rebased v18 patch on a clean tree and verified that it
applies cleanly and behaves consistently with previous results.
Cross-session access is correctly blocked with: ERROR: cannot access
temporary relations of other sessions
Index scan paths are also properly restricted, and same-session access
continues to work as expected.
The updated test changes look good. Everything works as expected, +1
from my side.

Regards,
Soumya

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Geier 2026-04-16 06:49:58 Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE
Previous Message David Geier 2026-04-16 06:38:45 Re: First draft of PG 19 release notes