Re: table inheritance partition and indexes

From: Ted Toth <txtoth(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: table inheritance partition and indexes
Date: 2022-11-23 22:34:02
Message-ID: CAFPpqQGaG9kWY0bLBdayR8Quszk-8hydj7R82CuSVADX89WiuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 23, 2022 at 4:01 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Ted Toth <txtoth(at)gmail(dot)com> writes:
> > On Wed, Nov 23, 2022 at 1:24 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> >> Out of curiosity, why INHERITS in v13 instead of PARTITION BY?
>
> > Because none of the declarative partition types do what I want.
>
> 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.

>
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2022-11-23 23:02:56 Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...
Previous Message Tom Lane 2022-11-23 22:01:47 Re: table inheritance partition and indexes