Request a Demo
Home   >   mailing lists

Re: We broke the defense against accessing other sessions' temp tables - Mailing list pgsql-hackers

From Jim Jones
Subject Re: We broke the defense against accessing other sessions' temp tables
Date
Msg-id afa4cd1b-bf8b-415e-8c4e-f2edb76156b0@uni-muenster.de
Whole thread Raw
In response to Re: We broke the defense against accessing other sessions' temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: We broke the defense against accessing other sessions' temp tables
List pgsql-hackers
Tree view 

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

pgsql-hackers by date:

Previous
From: Paul A Jungwirth
Date:
Subject: Re: SQL:2011 Application Time Update & Delete
Next
From: Tom Lane
Date:
Subject: Re: We broke the defense against accessing other sessions' temp tables