From: | Ted Toth <txtoth(at)gmail(dot)com> |
---|---|
To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: table inheritance partition and indexes |
Date: | 2022-11-25 15:03:28 |
Message-ID: | CAFPpqQF_a=jQzDt4y7A__-btRGstEik1hf0EvRq-KXQysbwJrg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Docs can always be better, right ;) When I went back and looked at the page
I did realize that the ATTACH INDEX command was only mentioned in the
description of declarative partitioning and not in the inheritance section
so I should have paid closer attention to the location.
Ted
On Wed, Nov 23, 2022 at 8:13 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> On Thu, 24 Nov 2022 at 11:34, Ted Toth <txtoth(at)gmail(dot)com> wrote:
> >
> > On Wed, Nov 23, 2022 at 4:01 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> Then you're stuck managing it manually. But ATTACH PARTITION is
> >> not relevant to INHERITS-style partitioning.
> >
> > That's the part that wasn't clear to me, thanks.
>
> Would this have been more clear if [1] didn't mention both declarative
> partitioning and inheritance partition on the same page? I've wondered
> before if we should split that into two separate pages.
>
> David
>
> [1]
> https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-11-25 15:05:33 | Re: How to select unique records in PostgreSQL |
Previous Message | Ron | 2022-11-25 14:50:08 | Re: How to select unique records in PostgreSQL |