pgsql: Fix handling of partition bounds for boolean partitioningcolumn
От | Tom Lane |
---|---|
Тема | pgsql: Fix handling of partition bounds for boolean partitioningcolumn |
Дата | |
Msg-id | E1fAh9R-0000d6-Fv@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix handling of partition bounds for boolean partitioning columns. Previously, you could partition by a boolean column as long as you spelled the bound values as string literals, for instance FOR VALUES IN ('t'). The trouble with this is that ruleutils.c printed that as FOR VALUES IN (TRUE), which is reasonable syntax but wasn't accepted by the grammar. That results in dump-and-reload failures for such cases. Apply a minimal fix that just causes TRUE and FALSE to be converted to strings 'true' and 'false'. This is pretty grotty, but it's too late for a more principled fix in v11 (to say nothing of v10). We should revisit the whole issue of how partition bound values are parsed for v12. Amit Langote Discussion: https://postgr.es/m/e05c5162-1103-7e37-d1ab-6de3e0afaf70@lab.ntt.co.jp Branch ------ REL_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1222db999dc8ad055e0320dd6704d814acca3b51 Modified Files -------------- doc/src/sgml/ref/create_table.sgml | 6 +++--- src/backend/parser/gram.y | 2 ++ src/test/regress/expected/create_table.out | 14 ++++++++++++++ src/test/regress/sql/create_table.sql | 7 +++++++ 4 files changed, 26 insertions(+), 3 deletions(-)
В списке pgsql-committers по дате отправления: