On 28.09.2017 16:29, Jesper Pedersen wrote:
On 09/28/2017 09:19 AM, Maksim Milyutin wrote:
E.g. "No partition constraint" vs. "Partition constraint: satisfies_hash_partition(...)".
I also noticed ambiguity in printing "No partition constraint" in non-verbose mode and "Partition constraint:..." in verbose one for partition tables regardless of the type of partition.
Attached small patch removes any output about partition constraint in non-verbose mode.
Yeah, that could be one way.
It should likely be backported to REL_10_STABLE, so the question is if we are too late in the release cycle to change that output.
I want to prepare more complete patch for "Partition constraint" output. For example, I encountered the primitive output with repetitive conjuncts for subpartition whose parent is partitioned by the same key:
Partition constraint: (
(i IS NOT NULL) AND (i >= 30) AND (i < 40) AND
(i IS NOT NULL) AND (i = ANY (ARRAY[30, 31])))
--
Regards,
Maksim Milyutin