On 2024-03-24 19:12 +0100, Thiemo Kellner wrote: > I have created a materialized view with "with data". And I refreshed it with > "with data". The query of the mv returns records when executed outside the > mv. I would appreciate help with respect to what I miss that my mv is empty.
Maybe you executed REFRESH in a transaction but did not commit it? > You might want to have a look at the code attached. I can't find any materialized view in your archive. -- Erik