On Thu, 28 Mar 2024 at 20:38, Erik Wienhold <e...@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.