Re: New partitioning - some feedback

On 2017/07/12 12:47, Ashutosh Bapat wrote:
> On Wed, Jul 12, 2017 at 8:23 AM, Amit Langote
> <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
>> On 2017/07/11 18:57, Ashutosh Bapat wrote:
>>> On Tue, Jul 11, 2017 at 4:16 AM, David Fetter <david(at)fetter(dot)org> wrote:
>>>> So whatever we land on needs to mention partition_of and
>>>> has_partitions. Is that latter just its immediate partitions?
>>>> Recursion all the way down? Somewhere in between?
>>>>
>>>
>>> We have patches proposed to address some of those concerns at [1]
>>>
>>> [1] https://www.postgresql.org/message-id/CAFjFpRcs5fOSfaAGAjT5C6=YvDD7MRx3knf_SpB5DQZOJgjerA@mail.gmail.com
>>
>> ISTM, David is talking about the "list tables" (bare \d without any
>> pattern) case. That is, listing partitioned tables as of type
>> "partitioned table" instead of "table" as we currently do. The linked
>> patch, OTOH, is for "describe table" (\d <object_name_pattern>) case.
>
> Right, the patches don't exactly do what David is suggesting, but
> those I believe have code to annotate the tables with "has partitions"
> and also the number of partitions (I guess). Although, that thread has
> died some time ago, so my memory can be vague.
>
> Do you see that those patches can be used in current discussion in any way?

It wouldn't really be a bad idea to put that patch here, because there's
no special reason for it to be in the CF for PG 11, if we are talking here
about changing \d command outputs anyway.

Thanks,
Amit