From: | Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Same expression more than once in partition key |
Date: | 2017-06-23 06:57:54 |
Message-ID: | 20170623155754.f1d25593.nagata@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
When we create a range partitioned table, we cannot use
a column more than once in the partition key.
postgres=# create table t (i int) partition by range(i,i);
ERROR: column "i" appears more than once in partition key
However, I can use same expression more than once in partition key.
postgres=# create table t (i int) partition by range((i),(i));
CREATE TABLE
Although this can be blocked by the attached parch, for example,
the following is still possible.
postgres=# create table t (i int) partition by range((i),i);
CREATE TABLE
Can these definition be a problem in the internal of partitioning?
If not, we might not need to check column that apears more than once
in the partition key.
Regards,
--
Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
From | Date | Subject | |
---|---|---|---|
Next Message | Ashutosh Bapat | 2017-06-23 07:01:04 | Re: Multi column range partition table |
Previous Message | atorikoshi | 2017-06-23 06:37:52 | Re: Fix a typo in README.dependencies |