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,
On Thu, 24 Nov 2022 at 11:34, Ted Toth wrote:
>
> On Wed, Nov 23, 2022 at 4:01 PM Tom Lane 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 cle
On Wed, Nov 23, 2022 at 4:01 PM Tom Lane wrote:
> Ted Toth writes:
> > On Wed, Nov 23, 2022 at 1:24 PM Ron 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.
Ted Toth writes:
> On Wed, Nov 23, 2022 at 1:24 PM Ron 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 parti
Because none of the declarative partition types do what I want.
On Wed, Nov 23, 2022 at 1:24 PM Ron wrote:
> Out of curiosity, why INHERITS in v13 instead of PARTITION BY?
>
> On 11/23/22 09:31, Ted Toth wrote:
> > I've created a table with a number of indexes and then created a
> partition
> >
Out of curiosity, why INHERITS in v13 instead of PARTITION BY?
On 11/23/22 09:31, Ted Toth wrote:
I've created a table with a number of indexes and then created a partition
table that inherits from it using "CREATE TABLE... INHERITS..." . I've
then queried pg_indexes on the parent for its index
