On Fri, Feb 14, 2020 at 05:59:34PM +0530, Ashutosh Bapat wrote:
> On Fri, Feb 14, 2020 at 11:35 AM Michael Paquier wrote:
>> One thing that we need to consider is if there are applications which
>> take advantage of LOCK allowed on temp relations from other backends
>> or not. One downside is tha
On Fri, Feb 14, 2020 at 11:35 AM Michael Paquier
wrote:
> On Thu, Feb 13, 2020 at 09:05:01PM +0530, Ashutosh Bapat wrote:
> > That looks odd. Other sessions are able to see temporary tables of a
> given
> > session because they are stored in the same catalog which is accessible
> to
> > all the s
On Thu, Feb 13, 2020 at 09:05:01PM +0530, Ashutosh Bapat wrote:
> That looks odd. Other sessions are able to see temporary tables of a given
> session because they are stored in the same catalog which is accessible to
> all the sessions. But ideally, a temporary table should be visible only to
> th
On Thu, Feb 13, 2020 at 6:40 PM Fujii Masao
wrote:
> Hi,
>
> TRUNCATE command on the temporary tables of other sessions fails
> with the following error. This behavior looks expected to me.
>
> ERROR: cannot truncate temporary tables of other sessions
>
> However I found that LOCK TABLE and
Hi,
TRUNCATE command on the temporary tables of other sessions fails
with the following error. This behavior looks expected to me.
ERROR: cannot truncate temporary tables of other sessions
However I found that LOCK TABLE and DROP TABLE commands on
the temporary tables of other sessions are
