Re: Empty materialized view - Mailing list pgsql-general

From Erik Wienhold
Subject Re: Empty materialized view
Date
Msg-id js3tqo6rnk7wttg2kinjvwto5a3gwi4watqokqx6em633thq5b@xe4hvo5qapsl
Whole thread Raw
In response to Empty materialized view  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Responses Re: Empty materialized view  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Is this a buggy behavior?
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Is this a buggy behavior?