Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-08 Thread Michael Paquier
On Tue, Nov 08, 2022 at 03:38:22PM +0900, Ian Lawrence Barwick wrote: > CF entry updated accordingly. Missed this part, thanks.. -- Michael signature.asc Description: PGP signature

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-07 Thread Ian Lawrence Barwick
2022年11月8日(火) 14:49 Michael Paquier : > > On Mon, Nov 07, 2022 at 01:43:22AM -0500, Tom Lane wrote: > > WFM. > > Okay, applied as bd95816, then. Thanks! CF entry updated accordingly. Regards Ian Barwick

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-07 Thread Michael Paquier
On Mon, Nov 07, 2022 at 01:43:22AM -0500, Tom Lane wrote: > WFM. Okay, applied as bd95816, then. -- Michael signature.asc Description: PGP signature

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-06 Thread Tom Lane
Michael Paquier writes: > On Sun, Nov 06, 2022 at 09:23:01PM +0900, Ian Lawrence Barwick wrote: >> Fair enough, make sense. > Fine by me and the patch looks OK. I'd like to apply this if there > are no objections. WFM. regards, tom lane

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-06 Thread Michael Paquier
On Sun, Nov 06, 2022 at 09:23:01PM +0900, Ian Lawrence Barwick wrote: > Fair enough, make sense. Fine by me and the patch looks OK. I'd like to apply this if there are no objections. -- Michael signature.asc Description: PGP signature

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-06 Thread Ian Lawrence Barwick
2022年11月6日(日) 1:39 Tom Lane : > > Michael Paquier writes: > > On Mon, Oct 24, 2022 at 09:44:18PM +0900, Ian Lawrence Barwick wrote: > >> Recently I have been working a lot with partitioned tables which contain a > >> mix > >> of local and foreign partitions, and find it would be very useful to be

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-11-05 Thread Tom Lane
Michael Paquier writes: > On Mon, Oct 24, 2022 at 09:44:18PM +0900, Ian Lawrence Barwick wrote: >> Recently I have been working a lot with partitioned tables which contain a >> mix >> of local and foreign partitions, and find it would be very useful to be able >> to >> easily obtain an overview

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-10-31 Thread Michael Paquier
On Mon, Oct 24, 2022 at 09:44:18PM +0900, Ian Lawrence Barwick wrote: > Recently I have been working a lot with partitioned tables which contain a mix > of local and foreign partitions, and find it would be very useful to be able > to > easily obtain an overview of which partitions are foreign and

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-10-31 Thread Ian Lawrence Barwick
2022年10月27日(木) 16:12 Alvaro Herrera : > > On 2022-Oct-24, Justin Pryzby wrote: > > > On Mon, Oct 24, 2022 at 09:44:18PM +0900, Ian Lawrence Barwick wrote: > > > > + else if (child_relkind == > > > RELKIND_FOREIGN_TABLE && is_partitioned) > > > +

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-10-27 Thread Alvaro Herrera
On 2022-Oct-24, Justin Pryzby wrote: > On Mon, Oct 24, 2022 at 09:44:18PM +0900, Ian Lawrence Barwick wrote: > > + else if (child_relkind == RELKIND_FOREIGN_TABLE > > && is_partitioned) > > + appendPQExpBuffer(&buf, ", server: > > \"%s

Re: [patch] Have psql's \d+ indicate foreign partitions

2022-10-24 Thread Justin Pryzby
On Mon, Oct 24, 2022 at 09:44:18PM +0900, Ian Lawrence Barwick wrote: > Recently I have been working a lot with partitioned tables which contain a mix > of local and foreign partitions, and find it would be very useful to be able > to > easily obtain an overview of which partitions are foreign and

[patch] Have psql's \d+ indicate foreign partitions

2022-10-24 Thread Ian Lawrence Barwick
Hi Recently I have been working a lot with partitioned tables which contain a mix of local and foreign partitions, and find it would be very useful to be able to easily obtain an overview of which partitions are foreign and where they are located. Currently, executing "\d+" on a partitioned table