| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: dropping partitioned tables without CASCADE |
| Date: | 2017-03-06 03:05:48 |
| Message-ID: | CANP8+jJOWUDw=_72Tx7=Urtw2anxdLujEix1txPnELCSuSpD1A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 6 March 2017 at 00:51, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yugo Nagata | 2017-03-06 03:12:21 | Re: Report the number of skipped frozen pages by manual VACUUM |
| Previous Message | Okano, Naoki | 2017-03-06 02:58:25 | Re: [WIP] RE: DECLARE STATEMENT setting up a connection in ECPG |