Re: Forbid to DROP temp tables of other sessions - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: Forbid to DROP temp tables of other sessions
Date
Msg-id 44B342BD-156C-4131-B2C0-845BF41B6B74@yandex-team.ru
Whole thread Raw
In response to Re: Forbid to DROP temp tables of other sessions  (Andres Freund <andres@anarazel.de>)
Responses Re: Forbid to DROP temp tables of other sessions
List pgsql-hackers

> On 22 Nov 2024, at 03:02, Andres Freund <andres@anarazel.de> wrote:
>
> I don't
> love having to put RELATION_IS_OTHER_TEMP() checks everywhere either.

+1. I do not understand why this restriction (protecting temp tables from access) is a responsibility of the buffer
manager.

Actually, I like the idea that superuser knows better what to do.
What if we say it's not a bug, but a feature. Will it break some contracts with user or some functionality?

It seems that protection of temp tables should belong to ACL stuff. And in a logic of this subsystem would be natural
tojust allow superuser do whatever they want with. 

Is it some lunatic idea? Or does it make some sense?


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Replace current implementations in crypt() and gen_salt() to OpenSSL
Next
From: Abhishek Kumar
Date:
Subject: Integrating HLL cardinality estimates with join operator estimation