Materialized views in postgres deployment do not update about rakam-api HOT 6 CLOSED

cache eviction duration PT5M
last updated at 1970-01-01T00:00:00Z

Error while updating materialized table '(SELECT * from taskhero."$materialized_segment_leavers" UNION ALL SELECT "id" FROM (SELECT * FROM taskhero."_users" WHERE "_time" > to_timestamp(1495130635)) data WHERE (("last_active_at" - interval '7 days') < "signup_date") ) data': ERROR: column "$server_time" does not exist Position: 112

do $$
declare
    selectrow record;
begin
for selectrow in
    select 
      'ALTER TABLE "'|| T.schemaname ||'"."'|| T.mytable || '" add column "$server_time" timestamp without time zone default (current_timestamp at time zone ''UTC'')' as script 
   from 
      ( 
        select schemaname, tablename as mytable from pg_tables t where schemaname  != 'public' and schemaname != 'pg_catalog' 
and (select count(*) from information_schema.columns where table_schema = t.schemaname and table_name = t.tablename and column_name = '$server_time')  = 0 
and tablename not like '$materialized%' and tablename != '_users' and schemaname != 'information_schema'
      ) t
loop
execute selectrow.script;

end loop;
end;
$$;

Error while updating materialized table '(SELECT * from taskhero."$materialized_segment_leavers" UNION ALL SELECT "id" FROM (SELECT * FROM taskhero."_users" WHERE "_time" > to_timestamp(1495132433)) data WHERE (("last_active_at" - interval '7 days') < "signup_date") ) data': ERROR: cannot change materialized view "$materialized_segment_leavers"

ERROR: relation "$materialized_segment_takers" does not exist Position: 178