From: Louis Brauer <louis77@mac.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Update materialized view definition kills indexes
Date: Tue, 25 Jun 2019 19:16:12 +0200
Message-ID: <8F364779-1FC9-4220-9449-B148596E3D5B@mac.com> (raw)
In-Reply-To: <896A21F4-F534-46C9-BF11-CDE6D0DC10BC@mac.com>
References: <896A21F4-F534-46C9-BF11-CDE6D0DC10BC@mac.com>
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 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: <8F364779-1FC9-4220-9449-B148596E3D5B@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