Re: table inheritance partition and indexes

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
>

In response to

Browse pgsql-general by date

  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