The following bug has been logged on the website:
Bug reference: 14725
Logged by: tian bing
Email address: tianbing(at)highgo(dot)com
PostgreSQL version: 10beta1
Operating system: Linux
Description:
Hi,
When I use two columns as the key of range partition to create partition
table.
postgres=# create table test(n1 int, n2 int) partition by range(n1, n2);
CREATE TABLE
postgres=# create table test_1 partition of test for values from (0,0) to
(10,100);
CREATE TABLE
postgres=# create table test_2 partition of test for values from (10,100) to
(20,50);
CREATE TABLE
In partition test_2, partition constraint of the second column seem to be
improper(from 100 to 50). The value behind keyword "TO" should be larger
than value behind keyword "FROM".
Looking forward to your reply.