| 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: | Whole Thread | Raw Message | 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 |