git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 90371a2) | patch
Remove undocumented restriction against duplicate partition key columns.
2018年7月19日 19:41:46 +0000 (15:41 -0400)
2018年7月19日 19:41:46 +0000 (15:41 -0400)
commit 24097167558bafbc1ea32f67ea5840e5650ad4e7
Remove undocumented restriction against duplicate partition key columns.

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 701fd0bbc),
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
src/backend/commands/tablecmds.c diff | blob | blame | history
src/test/regress/expected/create_table.out diff | blob | blame | history
src/test/regress/sql/create_table.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /