| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>, "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 20:07:08 |
| Message-ID: | a6e35e00-5d46-44fe-8fa5-bef19741ba4c@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2024-03-24 20:11:52 | Re: Empty materialized view |
| Previous Message | Peter J. Holzer | 2024-03-24 19:59:26 | Re: Is this a buggy behavior? |