table inheritance partition and indexes

From: Ted Toth <txtoth(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: table inheritance partition and indexes
Date: 2022-11-23 15:31:27
Message-ID: CAFPpqQFwdH2PeyoWXcSHYA8Fa+b_JFtGeiZqNQNk4W-EOYWo=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-11-23 16:16:16 Re: Fwd: Change the auth. postgresql and GIS
Previous Message Tom Lane 2022-11-23 14:29:19 Re: Index filter instead of index condition w/ IN / ANY queries above certain set size