MIME-Version: 1.0
References: 
 <CAOC+FBUas6PnmOpo1uUXwyV5a_==m6cPx-iVyDL3xDKeiqc1Kg@mail.gmail.com>
 <2406327.1725672781@sss.pgh.pa.us>
In-Reply-To: <2406327.1725672781@sss.pgh.pa.us>
From: Wells Oliver <wells.oliver@gmail.com>
Date: Fri, 6 Sep 2024 18:41:22 -0700
Message-ID: 
 <CAOC+FBWOTSi3DXHBjWdBrVpYOKTrf+aQ5N32BMDwJM3uKgfGXw@mail.gmail.com>
Subject: Re: pg_restore and materialized view deps
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000027753a06217da1fb"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOC%2BFBWOTSi3DXHBjWdBrVpYOKTrf%2BaQ5N32BMDwJM3uKgfGXw%40mail.gmail.com>
Precedence: bulk

--00000000000027753a06217da1fb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Ah, you know, a little deeper: it's an issue with a mat view unable to
refresh because it uses a function, and within that function, there is a
call to a mat view not yet materialized.


On Fri, Sep 6, 2024 at 6:33=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Wells Oliver <wells.oliver@gmail.com> writes:
> > 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.
>
> Oh?  There are dependencies that are supposed to prevent that.
> Can you provide a self-contained example of a schema where
> that doesn't work?
>
>                         regards, tom lane
>


--=20
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>

--00000000000027753a06217da1fb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-size:small">Ah,=
 you know, a little deeper: it&#39;s an issue with a mat view unable to ref=
resh because it uses a function, and within that function, there is a call =
to a mat view not yet materialized.</div><div class=3D"gmail_default" style=
=3D"font-size:small"><br></div><div class=3D"gmail_default" style=3D"font-s=
ize:small">=C2=A0<br></div></div><br><div class=3D"gmail_quote"><div dir=3D=
"ltr" class=3D"gmail_attr">On Fri, Sep 6, 2024 at 6:33=E2=80=AFPM Tom Lane =
&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<b=
r></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex">Wells Oliver &lt;=
<a href=3D"mailto:wells.oliver@gmail.com" target=3D"_blank">wells.oliver@gm=
ail.com</a>&gt; writes:<br>
&gt; Not the end of the world but I notice when running pg_restore that I<b=
r>
&gt; encounter a few errors where materialized views cannot be refreshed be=
cause<br>
&gt; they query other materialized views not yet refreshed.<br>
<br>
Oh?=C2=A0 There are dependencies that are supposed to prevent that.<br>
Can you provide a self-contained example of a schema where<br>
that doesn&#39;t work?<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Wells Oliver<br><a href=3D"mailto:wellsoliver@gmail.com=
" target=3D"_blank">wells.oliver@gmail.com</a></div></div></div>

--00000000000027753a06217da1fb--