table inheritance partition and indexes

Поиск
Список
Период
Сортировка
От Ted Toth
Тема table inheritance partition and indexes
Дата
Msg-id CAFPpqQFwdH2PeyoWXcSHYA8Fa+b_JFtGeiZqNQNk4W-EOYWo=g@mail.gmail.com
обсуждение исходный текст
Ответы Re: table inheritance partition and indexes  (Ron <ronljohnsonjr@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index filter instead of index condition w/ IN / ANY queries above certain set size
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Fwd: Change the auth. postgresql and GIS