Re: We broke the defense against accessing other sessions' temp tables

From: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: We broke the defense against accessing other sessions' temp tables
Date: 2025-10-04 21:07:33
Message-ID: afa4cd1b-bf8b-415e-8c4e-f2edb76156b0@uni-muenster.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/4/25 19:38, Tom Lane wrote:
> Sure. Superusers bypass all SQL permissions checks.

True. I just didn't expect this behavior to extend to temporary tables
as well. It was just a bit surprising that a temporary table can persist
after its owning session ends, simply because another session is holding
a lock on it --- without the owning session being aware of that.

Best, Jim

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-10-04 21:36:53 Re: We broke the defense against accessing other sessions' temp tables
Previous Message Paul A Jungwirth 2025-10-04 19:48:52 Re: SQL:2011 Application Time Update & Delete