Re: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes
От | Нагель Михаил |
---|---|
Тема | Re: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes |
Дата | |
Msg-id | 48379e12-4a9d-954e-78ce-2298f27cf67c@mail.ru обсуждение исходный текст |
Ответ на | Re: BUG #17009: create temporary table with like option using same name as persistent table does not create indexes (David Rowley <dgrowleyml@gmail.com>) |
Список | 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?
В списке pgsql-bugs по дате отправления: