Re: ALTER TABLE SET ACCESS METHOD on partitioned tables

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, pgsql-hackers(at)postgresql(dot)org, Ashwin Agrawal <ashwinstar(at)gmail(dot)com>, vanjared(at)vmware(dot)com, Alexander Lakhin <exclusion(at)gmail(dot)com>
Subject: Re: ALTER TABLE SET ACCESS METHOD on partitioned tables
Date: 2024-06-06 00:43:31
Message-ID: ZmEGMz7TC8SOIUpn@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 21, 2024 at 08:33:51AM -0500, Justin Pryzby wrote:
> It occurred to me that psql \dP+ should show the AM of partitioned
> tables (and other partitioned rels).
> Arguably, this could've been done when \dP was introduced in v12, but
> at that point would've shown the AM only for partitioned indexes.
> But it makes a lot of sense to do it now that partitioned tables support
> AMs. I suggest to consider this for v17.

Not sure that this is a must-have. It is nice to have, but extra
information is a new feature IMO. Any extra opinions?

I would suggest to attach a patch, that makes review easier. And so
here is one.
--
Michael

Attachment Content-Type Size
psql-dP-am.patch text/x-diff 1.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2024-06-06 00:53:09 Re: First draft of PG 17 release notes
Previous Message Jeff Davis 2024-06-06 00:23:25 tiny step toward threading: reduce dependence on setlocale()