Re: [HACKERS] Same expression more than once in partition key - Mailing list pgsql-hackers

From Yugo Nagata
Subject Re: [HACKERS] Same expression more than once in partition key
Date
Msg-id 20170623160916.5badfdbd.nagata@sraoss.co.jp
Whole thread Raw
In response to [HACKERS] Same expression more than once in partition key  (Yugo Nagata <nagata@sraoss.co.jp>)
List pgsql-hackers
On Fri, 23 Jun 2017 15:57:54 +0900
Yugo Nagata <nagata@sraoss.co.jp> wrote:

> 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.

I forgot to attach it.

> 
> 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@sraoss.co.jp>


-- 
Yugo Nagata <nagata@sraoss.co.jp>

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

Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Multi column range partition table
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Small bug in replication lag tracking