Re: Empty materialized view - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Empty materialized view
Date
Msg-id a6e35e00-5d46-44fe-8fa5-bef19741ba4c@aklaver.com
Whole thread Raw
In response to Empty materialized view  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
List pgsql-general
On 3/24/24 11:12, Thiemo Kellner wrote:
> Hi
> 
> 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. You might want to have a look at the code attached.

That does not contain the statements mentioned above. Provide a simple 
test case as code inline to your reply.

> 
> Kind regards
> 
> Thiemo

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Is this a buggy behavior?
Next
From: Thiemo Kellner
Date:
Subject: Re: Empty materialized view