Same expression more than once in partition key

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>

Responses

Browse pgsql-hackers by date

  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