Re: Empty materialized view

On 3/24/24 13:36, Thiemo Kellner wrote:
> Am 24.03.2024 um 21:30 schrieb Adrian Klaver:
>> On 3/24/24 13:11, Thiemo Kellner wrote:
>> Confirmed in the same session that created it or in a different session?
>
> Different session, not knowing what that mattered

It does depending on the order of viewing. Namely if you viewed the
'old' empty MV in the outside session before you dropped/created the
'new' MV and committed the changes.

>
> Excerpt of the installation protocol:
> …
> ## tenth level ##
> Set materialised view QUERY_PER_TASK⠒MV up
> psql:views/QUERY_PER_TASK⠒MV.pg_sql:3: HINWEIS:  materialisierte Sicht
> »query_per_task⠒mv« existiert nicht, wird übersprungen
> DROP MATERIALIZED VIEW
> SELECT 0
> REFRESH MATERIALIZED VIEW
> COMMENT
> COMMIT
> # insert data #
> …
>

> select count(*) from SNOWRUNNER.TASK_DEPENDENCY⠒V;

That is not the view you showed in your attached SQL in your previous
post nor what is mentioned above. Also if I am following your naming
scheme it is a regular view not a materialized view.

>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com