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.klaver@aklaver.com