[BUGS] BUG #14725: Partition constraint issue on multiple columns as the keyof range partition - Mailing list pgsql-bugs

From tianbing@highgo.com
Subject [BUGS] BUG #14725: Partition constraint issue on multiple columns as the keyof range partition
Date
Msg-id 20170701065244.1476.87707@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14725: Partition constraint issue on multiple columnsas the key of range partition
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14725
Logged by:          tian bing
Email address:      tianbing@highgo.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.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] BUG #14718: unable to update table with identity columnGENERATED ALWAYS
Next
From: dmigowski@ikoffice.de
Date:
Subject: [BUGS] BUG #14726: Memory consumption of PreparedStatement