• Tom Lane's avatar
    Remove undocumented restriction against duplicate partition key columns. · 24097167
    Tom Lane authored
    transformPartitionSpec rejected duplicate simple partition columns
    (e.g., "PARTITION BY RANGE (x,x)") but paid no attention to expression
    columns, resulting in inconsistent behavior.  Worse, cases like
    "PARTITION BY RANGE (x,(x))") were accepted but would then result in
    dump/reload failures, since the expression (x) would get simplified
    to a plain column later.
    
    There seems no better reason for this restriction than there was for
    the one against duplicate included index columns (cf commit 701fd0bb),
    so let's just remove it.
    
    Back-patch to v10 where this code was added.
    
    Report and patch by Yugo Nagata.
    
    Discussion: https://postgr.es/m/20180712165939.36b12aff.nagata@sraoss.co.jp
    24097167
tablecmds.c 459 KB