On 2017/06/24 5:04, Tom Lane wrote: > Peter Eisentraut <peter.eisentr...@2ndquadrant.com> writes: >> We also allow the same column more than once in an index. We probably >> don't have to be more strict here. > > There actually are valid uses for the same column more than once in > an index, eg if you use a different operator class for each instance. > I find it hard to envision a similar use-case in partitioning though.
So, does this mean we don't need to apply Nagata-san's patch for now? As far as the partitioning internals are concerned, I see no harm in allowing a column to appear more than once in the partition key. OTOH, I too don't see a partitioning use-case which would require it. Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
