Re: Empty materialized view

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Empty materialized view
Date: 2024-03-24 19:56:11
Message-ID: js3tqo6rnk7wttg2kinjvwto5a3gwi4watqokqx6em633thq5b@xe4hvo5qapsl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2024-03-24 19:59:26 Re: Is this a buggy behavior?
Previous Message David G. Johnston 2024-03-24 18:23:22 Re: Is this a buggy behavior?