Postgres Pro
Downloads
Home   >   mailing lists

Re: table inheritance partition and indexes - Mailing list pgsql-general

From Ted Toth
Subject Re: table inheritance partition and indexes
Date
Msg-id CAFPpqQGaG9kWY0bLBdayR8Quszk-8hydj7R82CuSVADX89WiuA@mail.gmail.com
Whole thread Raw
In response to Re: table inheritance partition and indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: table inheritance partition and indexes  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
Tree view


On Wed, Nov 23, 2022 at 4:01 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ted Toth <txtoth@gmail.com> writes:
> On Wed, Nov 23, 2022 at 1:24 PM Ron <ronljohnsonjr@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: table inheritance partition and indexes
Next
From: Andres Freund
Date:
Subject: Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...