Re: [HACKERS] Adding support for Default partition in partitioning
| От | Rajkumar Raghuwanshi |
|---|---|
| Тема | Re: [HACKERS] Adding support for Default partition in partitioning |
| Дата | |
| Msg-id | CAKcux6nAt+5k=CKS-fSD++-Nd+PGb7vo7ccxbHmwDdBBioBgiw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] Adding support for Default partition in partitioning (Rahila Syed <rahilasyed90@gmail.com>) |
| Ответы |
Re: [HACKERS] Adding support for Default partition in partitioning
|
| Список | pgsql-hackers |
On Thu, May 4, 2017 at 5:14 PM, Rahila Syed <rahilasyed90@gmail.com> wrote:
create table lpd (a int, b int, c varchar) partition by list(a);
create table lpd_d partition of lpd DEFAULT;
\d+ lpd
Table "public.lpd"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+-------------------+-----------+----------+---------+----------+--------------+-------------
a | integer | | | | plain | |
b | integer | | | | plain | |
c | character varying | | | | extended | |
Partition key: LIST (a)
Partitions: lpd_d FOR VALUES IN (DEFAULT)
The syntax implemented in this patch is as follows,
CREATE TABLE p11 PARTITION OF p1 DEFAULT;
Applied v9 patches, table description still showing old pattern of default partition. Is it expected?
create table lpd (a int, b int, c varchar) partition by list(a);
create table lpd_d partition of lpd DEFAULT;
\d+ lpd
Table "public.lpd"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+-------------------+-----------+----------+---------+----------+--------------+-------------
a | integer | | | | plain | |
b | integer | | | | plain | |
c | character varying | | | | extended | |
Partition key: LIST (a)
Partitions: lpd_d FOR VALUES IN (DEFAULT)
В списке pgsql-hackers по дате отправления: