BUG #15565: truncate bug with tables which have temp table inherited
От | PG Bug reporting form |
---|---|
Тема | BUG #15565: truncate bug with tables which have temp table inherited |
Дата | |
Msg-id | 15565-ce67a48d0244436a@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15565: truncate bug with tables which have temp tableinherited
Re: BUG #15565: truncate bug with tables which have temp tableinherited Re: BUG #15565: truncate bug with tables which have temp table inherited |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15565 Logged by: Zhou Digoal Email address: digoal@126.com PostgreSQL version: 11.1 Operating system: CentOS 7.x x64 Description: ``` 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 ``` but delete,select,update is ok; ``` postgres=# select * from public. postgres-# a; id ---- (0 rows) postgres=# delete from public.a postgres-# ; DELETE 0 postgres=# update public.a set id=1; UPDATE 0 postgres=# \d+ public.a Table "public.a" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description --------+---------+-----------+----------+---------+---------+--------------+------------- id | integer | | | | plain | | Child tables: a, pg_temp_3.a ```
В списке pgsql-bugs по дате отправления: