Re: Empty materialized view - Mailing list pgsql-general

From Thiemo Kellner
Subject Re: Empty materialized view
Date
Msg-id 2ec1a2bd-7791-4cc5-90ed-1b7b606aa420@gelassene-pferde.biz
Whole thread Raw
In response to Re: Empty materialized view  (Erik Wienhold <ewie@ewie.name>)
Responses Re: Empty materialized view  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Empty materialized view
Next
From: Adrian Klaver
Date:
Subject: Re: Empty materialized view