Re: Update materialized view definition kills indexes

2019-06-26 Thread Khushboo Vashi
On Tue, Jun 25, 2019 at 10:45 PM Louis Brauer wrote: > 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 t

Update materialized view definition kills indexes

2019-06-25 Thread Louis Brauer
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? - Lou