Re: Forbid to DROP temp tables of other sessions

> 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.