pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Update 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