Обсуждение: Update materialized view definition kills indexes

Поиск
Список
Период
Сортировка

Update materialized view definition kills indexes

От
Louis Brauer
Дата:
Hi there

I’ve noticed that in the recent version of pgAdmin 4.8 when I update the definition of a MATERIALIZED VIEW, the indexed
willnot be recreated. 

Personally I think that pgAdmin should recreate the indexes or at least warn the user that the indexes will be gone.

What do you think?

- Louis


Re: Update materialized view definition kills indexes

От
Louis Brauer
Дата:
Sorry guys, wrong list. Apologies!

> Am 25.06.2019 um 19:14 schrieb Louis Brauer <louis77@mac.com>:
>
> Hi there
>
> I’ve noticed that in the recent version of pgAdmin 4.8 when I update the definition of a MATERIALIZED VIEW, the
indexedwill not be recreated. 
>
> Personally I think that pgAdmin should recreate the indexes or at least warn the user that the indexes will be gone.
>
> What do you think?
>
> - Louis
>