Re: ALTER INDEX fails on partitioned index

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: ALTER INDEX fails on partitioned index
Дата
Msg-id
20200228001114.GA16911@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
ALTER INDEX fails on partitioned index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER INDEX fails on partitioned index Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ALTER INDEX fails on partitioned index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER INDEX fails on partitioned index Michael Paquier <michael@paquier.xyz>
Re: ALTER INDEX fails on partitioned index Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ALTER INDEX fails on partitioned index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER INDEX fails on partitioned index Robert Haas <robertmhaas@gmail.com>
Re: ALTER INDEX fails on partitioned index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER INDEX fails on partitioned index Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ALTER INDEX fails on partitioned index Michael Paquier <michael@paquier.xyz>
Re: ALTER INDEX fails on partitioned index Justin Pryzby <pryzby@telsasoft.com>
On 2020-Feb-27, Justin Pryzby wrote:

> The attached allows CREATE/ALTER to specify reloptions on a partitioned table
> which are used as defaults for future children.
> 
> I think that's a desirable behavior, same as for tablespaces.  Michael
> mentioned that ALTER INDEX ONLY doesn't exist, but that's only an issue if
> ALTER acts recursively, which isn't the case here.

I think ALTER not acting recursively is a bug that we would do well not
to propagate any further.  Enough effort we have to spend trying to fix
that already.  Let's add ALTER .. ONLY if needed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Tomas Vondra
Дата:
FAQ