[bug report] About create table like feature's bug
| От | dengkai | 
|---|---|
| Тема | [bug report] About create table like feature's bug | 
| Дата | |
| Msg-id | tencent_83CB623256F68B1CBE13201DE8C51BFB8006@qq.com обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: [bug report] About create table like feature's bug
            		
            		 | 
		
| Список | pgsql-bugs | 
postgres=# create table t1(c1 int, c2 char(10));
CREATE TABLE
postgres=# create index idx1 on t1(c1);
CREATE INDEX
postgres=# \d+ t1
Table "public.t1"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
--------+---------------+-----------+----------+---------+----------+-------------+--------------+-------------
c1 | integer | | | | plain | | |
c2 | character(10) | | | | extended | | |
Indexes:
"idx1" btree (c1)
Access method: heap
postgres=# create table t2(like t1 including indexes);
CREATE TABLE
postgres=# \d+ t2
Table "public.t2"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
--------+---------------+-----------+----------+---------+----------+-------------+--------------+-------------
c1 | integer | | | | plain | | |
c2 | character(10) | | | | extended | | |
Indexes:
"t2_c1_idx" btree (c1)
Access method: heap
postgres=# select version();
version
------------------------------------------------------------------------------------------------------------
PostgreSQL 16devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)
В списке pgsql-bugs по дате отправления: