From: Louis Brauer <louis77@mac.com>
To: pgsql-admin@lists.postgresql.org
Subject: Update materialized view definition kills indexes
Date: Tue, 25 Jun 2019 19:14:03 +0200
Message-ID: <896A21F4-F534-46C9-BF11-CDE6D0DC10BC@mac.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: louis77@mac.com, pgsql-admin@lists.postgresql.org
Subject: Re: Update materialized view definition kills indexes
In-Reply-To: <896A21F4-F534-46C9-BF11-CDE6D0DC10BC@mac.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox