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

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: Erik Wienhold <ewie(at)ewie(dot)name>
Cc: Kirk Wolak <wolakk(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PSQL Should \sv & \ev work with materialized views?
Date: 2024-03-29 03:27:48
Message-ID: CAMsGm5fzAXWrpK6TzrWYkbJ6wYwpxpOHyeoEjt086k5-FXtGVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 28 Mar 2024 at 20:38, Erik Wienhold <ewie(at)ewie(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-03-29 03:33:37 Re: AIX support
Previous Message jian he 2024-03-29 03:20:00 Re: remaining sql/json patches