Re: BUG #15728: an index that created with keyword ONLY, when add newpartition ,should not be auto created

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #15728: an index that created with keyword ONLY, when add newpartition ,should not be auto created
Дата
Msg-id CAKFQuwZh1yq8FBdBZte8TG9d_PjXMkSysoUMns9=z=Bh8g-yiw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15728: an index that created with keyword ONLY, when add new partition ,should not be auto created  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Apr 2, 2019 at 4:04 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15728
Logged by:          DamionZ Zhao
Email address:      zhq651@126.com
PostgreSQL version: 11.2
Operating system:   linux
Description:       
[...]
we see that index on population is created automaticly. Does it make sense?
ONLY's means is different between  created partiton and new partition.

Documented behavior.

"""
If the ONLY option is specified, no recursion is done, and the index is marked invalid. (ALTER INDEX ... ATTACH PARTITION marks the index valid, once all partitions acquire matching indexes.) Note, however, that any partition that is created in the future using CREATE TABLE ... PARTITION OF will automatically have a matching index, regardless of whether ONLY is specified.
"""

https://www.postgresql.org/docs/11/sql-createindex.html (Notes section)

David J.

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15728: an index that created with keyword ONLY, when add new partition ,should not be auto created
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15726: parallel queries failed ERROR: invalid name syntax CONTEXT: parallel worker