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 CAJDiXggEU0HQFDLFQOashtgwuiODW_+ZoViM1rn=P3DMraTRAg@mail.gmail.com
Whole thread Raw
In response to Re: Forbid to DROP temp tables of other sessions  (vignesh C <vignesh21@gmail.com>)
Responses Re: Forbid to DROP temp tables of other sessions
List pgsql-hackers
Hi,

On Sun, Mar 16, 2025 at 7:53 PM vignesh C <vignesh21@gmail.com> wrote:
> I noticed that the following Andrey's comment regarding the isolation
> test from [1] and Andres's comment  from [2] are pending. I'm changing
> the commitfest entry to Waiting on Author, please provide an updated
> patch and update it to Needs review.

Thanks for reading it.
I saw [2] and introduced a possible solution in my last letter. In
short : we can have a GUC variable that will permit superuser to drop
temp tables of other sessions. Thus, we have a single location in code
that will check whether we can perform operations with other temp
tables. As far as I understand, this is exactly what Andres wrote
about.
Also, it is difficult for me to express my opinion on [1] at the
moment. I can say for sure that the tests will change when we agree on
the behavior of the code. Therefore, I suggest postponing the
resolution of this issue.

> I suggest adding a GUC that will allow superuser to do this
Waiting for your feedback on this issue :)

--
Best regards,
Daniil Davydov



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: More Perl cleanups
Next
From: Amit Kapila
Date:
Subject: Re: long-standing data loss bug in initial sync of logical replication