Update materialized view definition kills indexes

From: Louis Brauer <louis77(at)mac(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Update materialized view definition kills indexes
Date: 2019-06-25 17:14:03
Message-ID: 896A21F4-F534-46C9-BF11-CDE6D0DC10BC@mac.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 will 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Louis Brauer 2019-06-25 17:16:12 Re: Update materialized view definition kills indexes
Previous Message SBob 2019-06-21 14:11:52 Re: Vacuum not cleaning up rows.