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