Horton

Re: PSQL Should \sv & \ev work with materialized views?

Isaac Morland <isaac.morland@gmail.com>

View thread
From: Isaac Morland <isaac.morland@gmail.com>
To: Erik Wienhold <ewie@ewie.name>
Cc: Kirk Wolak <wolakk@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-03-29T03:27:48Z
Lists: pgsql-hackers 
On Thu, 28 Mar 2024 at 20:38, Erik Wienhold <ewie@ewie.name> wrote:


> Of course the problem with using DROP and CREATE is that indexes and
> privileges (anything else?) must also be restored.  I haven't bothered
> with that yet.
>

Not just those — also anything that depends on the matview, such as views
and other matviews.