Re: table inheritance partition and indexes

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Ted Toth <txtoth(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-24 02:13:37
Message-ID: CAApHDvpGszDLakKib6DtRudJiWsiKgss0b2yk5yDQHfMqWhmkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2022-11-24 02:22:05 Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...
Previous Message Kirk Wolak 2022-11-24 02:04:25 Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...