| From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
|---|---|
| To: | "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:11:52 |
| Message-ID: | 2ec1a2bd-7791-4cc5-90ed-1b7b606aa420@gelassene-pferde.biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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).
> 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.
| Attachment | Content-Type | Size |
|---|---|---|
| QUERY_PER_TASK⠒MV.pg_sql | text/plain | 4.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2024-03-24 20:30:28 | Re: Empty materialized view |
| Previous Message | Adrian Klaver | 2024-03-24 20:07:08 | Re: Empty materialized view |