Re: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes

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?

In response to

Responses

Browse pgsql-bugs by date

  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)