Re: BUG #15565: truncate bug with tables which have temp table inherited - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #15565: truncate bug with tables which have temp table inherited
Date
Msg-id CAKJS1f-bXtPpxpy=TvbJSX_418JQh=Dg9viBa51DiYotLrD30Q@mail.gmail.com
Whole thread Raw
In response to BUG #15565: truncate bug with tables which have temp table inherited  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Tue, 25 Dec 2018 at 05:11, PG Bug reporting form
<noreply@postgresql.org> wrote:
> ```
> create table public.a (id int);
> ```
>
> sesssion a:
>
> ```
> create temp table a (like public.a) inherits(public.a);
> ```
>
> session b:
> ```
> create temp table a (like public.a) inherits(public.a);
> ```
>
> any session:
>
> ```
> postgres=# truncate public.a;
> ERROR:  cannot truncate temporary tables of other sessions

Is this blocking a real-world use case? Or did you just happen to
stumble on this?

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-bugs by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: BUG #15552: Unexpected error in COPY to a foreign table in atransaction
Next
From: David Rowley
Date:
Subject: Re: BUG #15565: truncate bug with tables which have temp table inherited