Re: Empty materialized view

Поиск
Список
Период
Сортировка
От Erik Wienhold
Тема Re: Empty materialized view
Дата
Msg-id js3tqo6rnk7wttg2kinjvwto5a3gwi4watqokqx6em633thq5b@xe4hvo5qapsl
обсуждение исходный текст
Ответ на Empty materialized view  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Ответы Re: Empty materialized view
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Is this a buggy behavior?
Следующее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Is this a buggy behavior?