From: | Нагель Михаил <Misha_Nagel(at)mail(dot)ru> |
---|---|
To: | David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes |
Date: | 2021-05-14 10:55:17 |
Message-ID: | 48379e12-4a9d-954e-78ce-2298f27cf67c@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> If you upgrade to 12.6 or 12.7, does it work?
Good afternoon, David.
After updating to 12.7, the bug really disappeared:
postgres=# select version();
version
------------------------------------------------------------
PostgreSQL 12.7, compiled by Visual C++ build 1914, 64-bit
(1 строка)
postgres=# create table t_tmp (a int);
CREATE TABLE
postgres=# create index on t_tmp (a);
CREATE INDEX
postgres=#
postgres=# create temporary table t_tmp (like t_tmp including all);
CREATE TABLE
postgres=#
postgres=# select *
postgres-# from pg_catalog.pg_indexes
postgres-# where tablename like 't_tmp%';
schemaname | tablename | indexname | tablespace
| indexdef
------------+-----------+-------------+------------+-------------------------------------------------------------
public | t_tmp | t_tmp_a_idx | | CREATE INDEX
t_tmp_a_idx ON public.t_tmp USING btree (a)
pg_temp_3 | t_tmp | t_tmp_a_idx | | CREATE INDEX
t_tmp_a_idx ON pg_temp_3.t_tmp USING btree (a)
(2 строки)
Do I understand correctly that the solution in my case is to upgrade to
at least 12.6?
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2021-05-14 11:02:54 | Re: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes |
Previous Message | Eric Thinnes | 2021-05-14 10:54:08 | Segmentation fault when calling BlessTupleDesc in a C function in parallel on PostgreSQL-(12.6, 12.7, 13.2, 13.3) |