Because none of the declarative partition types do what I want. On Wed, Nov 23, 2022 at 1:24 PM Ron <ronljohnso...@gmail.com> 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 > > table that inherits from it using "CREATE TABLE... INHERITS..." . I've > > then queried pg_indexes on the parent for its indexes and tried creating > > matching indexes on the child and attaching them to the parent table > > indexes. However "ALTER TABLE ... ATTACH PARTITION ..." is returning the > > error "<parent tables index name> is not a table partitioned index". > I've > > followed the inheritance partitioning example and read the "CREATE > INDEX" > > docs but I must be missing something, can anyone help me understand what > > I'm doing wrong? I'm using version 13. > > > > Ted > > > > -- > Angular momentum makes the world go 'round. > > >
