| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | digoal(at)126(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #15565: truncate bug with tables which have temp table inherited |
| Date: | 2018-12-25 07:25:21 |
| Message-ID: | CAKJS1f-bXtPpxpy=TvbJSX_418JQh=Dg9viBa51DiYotLrD30Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, 25 Dec 2018 at 05:11, PG Bug reporting form
<noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-12-25 07:27:19 | Re: BUG #15565: truncate bug with tables which have temp table inherited |
| Previous Message | Etsuro Fujita | 2018-12-25 01:48:05 | Re: BUG #15552: Unexpected error in COPY to a foreign table in a transaction |