Re: Problem on pg_dump RANGE partition with expressions

2018-07-19 Thread Tom Lane
Yugo Nagata writes: > Attached is a patch to get rid of "appears more than once" restriction. Pushed. (Again, it'd have been helpful if you updated the regression tests.) regards, tom lane

Re: Problem on pg_dump RANGE partition with expressions

2018-07-13 Thread Yugo Nagata
On Thu, 12 Jul 2018 17:44:48 +0900 Amit Langote wrote: > > 1) Allow to appear more than once in range partition key > > > > I don't understand why there is this restriction. If we have no clear > > reason, > > can we rip out this restrition? > > I can't recall exactly, but back when I wrote

Re: Problem on pg_dump RANGE partition with expressions

2018-07-12 Thread Amit Langote
Nagata-san, On 2018/07/12 16:59, Yugo Nagata wrote: > Hi, > > During looking into other thread[1], I found a problem on pg_dump of range > partition table using expressions. When we create a range partitioned table, > we cannot use a column more than once in the partition key. > > postgres=#

Problem on pg_dump RANGE partition with expressions

2018-07-12 Thread Yugo Nagata
Hi, During looking into other thread[1], I found a problem on pg_dump of range partition table using expressions. 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