Re: [HACKERS] Partitions: \d vs \d+

2017-09-29 Thread Robert Haas
On Thu, Sep 28, 2017 at 9:33 PM, Amit Langote wrote: > Perhaps, there is no case when "No partition constraint" should be output, > but I may be missing something. The case arises when a partitioned table has a default partition but no other partitions. I have

Re: [HACKERS] Partitions: \d vs \d+

2017-09-29 Thread Maksim Milyutin
On 29.09.2017 04:33, Amit Langote wrote: So, we should be looking at partconstraintdef only when verbose is true, because that's only when we set it to a valid value. Now, if partconstraintdef is NULL even after verbose is true, that means backend returned that there exists no constraint for

Re: [HACKERS] Partitions: \d vs \d+

2017-09-28 Thread Amit Langote
On 2017/09/28 22:19, Maksim Milyutin wrote: > 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

Re: [HACKERS] Partitions: \d vs \d+

2017-09-28 Thread Amit Langote
On 2017/09/28 22: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

Re: [HACKERS] Partitions: \d vs \d+

2017-09-28 Thread Maksim Milyutin
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

Re: [HACKERS] Partitions: \d vs \d+

2017-09-28 Thread Jesper Pedersen
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

Re: [HACKERS] Partitions: \d vs \d+

2017-09-28 Thread Maksim Milyutin
Hi! On 28.09.2017 16:02, Jesper Pedersen wrote: Hi, Using hash partitions I noticed that \d gives D=# \d T_p63    Table "public.T_p63"     Column | Type  | Collation | Nullable | Default ---+---+---+--+- Partition of: