Re: [HACKERS] dropping partitioned tables without CASCADE - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] dropping partitioned tables without CASCADE
Date
Msg-id CANP8+jJOWUDw=_72Tx7=Urtw2anxdLujEix1txPnELCSuSpD1A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] dropping partitioned tables without CASCADE  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: [HACKERS] dropping partitioned tables without CASCADE  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
On 6 March 2017 at 00:51, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> wrote:
> On 2017/03/05 16:20, Simon Riggs wrote:
>> I notice also that
>>   \d+ <tablename>
>> does not show which partitions have subpartitions.
>
> Do you mean showing just whether a partition is itself partitioned or
> showing its partitions and so on (because those partitions may themselves
> be partitioned)?  Maybe, we could do the former.

I think \d+ should show the full information, in some form.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: "Okano, Naoki"
Date:
Subject: Re: [WIP] RE: [HACKERS] DECLARE STATEMENT setting up a connectionin ECPG
Next
From: Yugo Nagata
Date:
Subject: Re: [HACKERS] Report the number of skipped frozen pages by manualVACUUM