[HACKERS] Same expression more than once in partition key
От | Yugo Nagata |
---|---|
Тема | [HACKERS] Same expression more than once in partition key |
Дата | |
Msg-id | 20170623155754.f1d25593.nagata@sraoss.co.jp обсуждение исходный текст |
Ответы |
Re: [HACKERS] Same expression more than once in partition key
Re: [HACKERS] Same expression more than once in partition key |
Список | 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@sraoss.co.jp>
В списке pgsql-hackers по дате отправления: