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.klaver@xxxxxxxxxxx