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.kla...@aklaver.com



Reply via email to