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

From Daniil Davydov
Subject Re: Forbid to DROP temp tables of other sessions
Date
Msg-id CAJDiXgh4YtofoVm5QvBUJ0Bsg-Pn8+mGS61BRzzyE9ur=ziwnQ@mail.gmail.com
Whole thread Raw
In response to Re: Forbid to DROP temp tables of other sessions  (Maxim Orlov <orlovmg@gmail.com>)
List pgsql-hackers
Hi,
I'm sorry for the long lull.
Considering that it is still important for some users to be able to
clean other sessions' temporary directories, I suggest adding a GUC
that will allow superuser to do this.
We keep only one option - to drop tables, because only this feature
works properly in postgres by now.

The ability to read and modify other session's temp tables is broken
(I mean INSERT, UPDATE, DELETE, SELECT queries) and needs to be
disabled.
I wrote about broken INSERTs here :
https://www.postgresql.org/message-id/CAJDiXgj6TBzn%3D6Ezx7%2B9BNa9HpBitBU%2BMuv-N3mHeN_Zs3NBDw%40mail.gmail.com

What do you think about this idea?

--
Best regards,
Daniil Davydov



pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: Improve CRC32C performance on SSE4.2
Next
From: Tom Lane
Date:
Subject: Re: missing assert in makeString