| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Empty materialized view |
| Date: | 2024-03-24 20:30:28 |
| Message-ID: | 61e2c2b7-1098-4179-91a2-24e06e0683a9@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/24/24 13:11, Thiemo Kellner wrote:
>
>
> Am 24.03.2024 um 20:56 schrieb Erik Wienhold:
>> Maybe you executed REFRESH in a transaction but did not commit it?
>
> While I can see the point for the refresh (but there actually is a
> commit), I cannot hold it valid for a create with data when the mv
> actually is created (confirmed by being empty).
Confirmed in the same session that created it or in a different session?
>
>> I can't find any materialized view in your archive.
>
> Oh sh*. That is the file, I forgot to commit. Please find it attached now.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2024-03-24 20:36:55 | Re: Empty materialized view |
| Previous Message | Thiemo Kellner | 2024-03-24 20:11:52 | Re: Empty materialized view |