pg_restore and materialized view deps

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_restore and materialized view deps
Date: 2024-09-07 00:41:52
Message-ID: CAOC+FBUas6PnmOpo1uUXwyV5a_==m6cPx-iVyDL3xDKeiqc1Kg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Not the end of the world but I notice when running pg_restore that I
encounter a few errors where materialized views cannot be refreshed because
they query other materialized views not yet refreshed.

Is this a fixable thing or just something one must live with, and refresh
them after the restore?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2024-09-07 01:33:01 Re: pg_restore and materialized view deps
Previous Message Sam Stearns 2024-09-06 21:22:48 Re: Book