pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpdate materialized view definition kills indexes
2+ messages / 1 participants
[nested] [flat]
* Update materialized view definition kills indexes
@ 2019-06-25 17:14 Louis Brauer <louis77@mac.com>
2019-06-25 17:16 ` Re: Update materialized view definition kills indexes Louis Brauer <louis77@mac.com>
0 siblings, 1 reply; 2+ messages in thread
From: Louis Brauer @ 2019-06-25 17:14 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Update materialized view definition kills indexes
2019-06-25 17:14 Update materialized view definition kills indexes Louis Brauer <louis77@mac.com>
@ 2019-06-25 17:16 ` Louis Brauer <louis77@mac.com>
0 siblings, 0 replies; 2+ messages in thread
From: Louis Brauer @ 2019-06-25 17:16 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-06-25 17:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-06-25 17:14 Update materialized view definition kills indexes Louis Brauer <louis77@mac.com>
2019-06-25 17:16 ` Louis Brauer <louis77@mac.com>
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