Thread: declarative partition by list, "other values" syntax

declarative partition by list, "other values" syntax

From
legrand legrand
Date:
Hello,

I was trying to create a partitionned table by list,
that has on special partition for "other values"

for exemple
create table wiki_data_part(  category varchar(20),  tim_id bigint,  pag_id bigint,  requests int,  size bigint
) 
PARTITION BY LIST (category );

CREATE TABLE wiki_data_part_a PARTITION OF wiki_data_part
FOR VALUES IN ('ang.q','ace.mw', ...);

CREATE TABLE wiki_data_part_b PARTITION OF wiki_data_part
FOR VALUES IN ('bs.s','bh.mw','bar','br.d', ...);

How could I create a partition containing the other values (like MINVALUE,
MAXVALUE for range partition) ?

CREATE TABLE wiki_data_part_others PARTITION OF wiki_data_part
FOR VALUES IN (others);

could not find it in doc
https://www.postgresql.org/docs/10/static/sql-createtable.html

Thanks in advance
Regards
PAscal




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


Re: declarative partition by list, "other values" syntax

From
legrand legrand
Date:
Found it in pg 11devel:

CREATE TABLE wiki_data_part_a PARTITION OF wiki_data_part DEFAULT;




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html