Postgres Pro
Downloads
Home   >   mailing lists

Update materialized view definition kills indexes - Mailing list pgsql-admin

From Louis Brauer
Subject Update materialized view definition kills indexes
Date
Msg-id 896A21F4-F534-46C9-BF11-CDE6D0DC10BC@mac.com
Whole thread Raw
Responses Re: Update materialized view definition kills indexes  (Louis Brauer <louis77@mac.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: SBob
Date:
Subject: Re: Vacuum not cleaning up rows.
Next
From: Louis Brauer
Date:
Subject: Re: Update materialized view definition kills indexes