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

Поиск
Список
Период
Сортировка
Искать
От
Jim Jones
Тема
Re: We broke the defense against accessing other sessions' temp tables
Дата
Msg-id
afa4cd1b-bf8b-415e-8c4e-f2edb76156b0@uni-muenster.de
Ответ на
Re: We broke the defense against accessing other sessions' temp tables (Tom Lane)
Список
Дерево обсуждения
We broke the defense against accessing other sessions' temp tables Tom Lane <tgl@sss.pgh.pa.us>
Re: We broke the defense against accessing other sessions' temp tables Bruce Momjian <bruce@momjian.us>
Re: We broke the defense against accessing other sessions' temp tables Tom Lane <tgl@sss.pgh.pa.us>
Re: We broke the defense against accessing other sessions' temp tables Bruce Momjian <bruce@momjian.us>
Re: We broke the defense against accessing other sessions' temp tables Jelte Fennema-Nio <postgres@jeltef.nl>
Re: We broke the defense against accessing other sessions' temp tables "David G. Johnston" <david.g.johnston@gmail.com>
Re: We broke the defense against accessing other sessions' temp tables Jim Jones <jim.jones@uni-muenster.de>
Re: We broke the defense against accessing other sessions' temp tables Tom Lane <tgl@sss.pgh.pa.us>
Re: We broke the defense against accessing other sessions' temp tables Jim Jones <jim.jones@uni-muenster.de>
Re: We broke the defense against accessing other sessions' temp tables Tom Lane <tgl@sss.pgh.pa.us>
Re: We broke the defense against accessing other sessions' temp tables Jim Jones <jim.jones@uni-muenster.de>
Re: We broke the defense against accessing other sessions' temp tables Thomas Munro <thomas.munro@gmail.com>
Re: We broke the defense against accessing other sessions' temp tables Tom Lane <tgl@sss.pgh.pa.us>
Re: We broke the defense against accessing other sessions' temp tables Jim Jones <jim.jones@uni-muenster.de>
Re: We broke the defense against accessing other sessions' temp tables Thomas Munro <thomas.munro@gmail.com> 


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 по дате отправления
Предыдущее
От: Paul A Jungwirth
Дата:
Следующее
От: Tom Lane
Дата:
FAQ