Re: PG11 Hash partitioning and null values in the partition key

2018-07-13 Thread Daniel Westermann
Hi, given this setup: create table part2 ( a int, list varchar(10) ) partition by hash (a); create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER 0); create table part2_2 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER 1); create table part2_3 partition

Re: PG11 Hash partitioning and null values in the partition key

2018-07-13 Thread amul sul
On Fri, Jul 13, 2018, 7:35 PM Daniel Westermann < daniel.westerm...@dbi-services.com> wrote: > Hi, > > given this setup: > > create table part2 ( a int, list varchar(10) ) partition by hash (a); > create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3, > REMAINDER 0); > create table pa

PG11 Hash partitioning and null values in the partition key

2018-07-13 Thread Daniel Westermann
Hi, given this setup: create table part2 ( a int, list varchar(10) ) partition by hash (a); create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER 0); create table part2_2 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER 1); create table part2_3 partition of