Laurenz Albe <laurenz.albe@cybertec.at> writes: > Nicola Contu wrote: >> pg_restore: [archiver (db)] could not execute query: ERROR: relation "all_days" does not exist >> LINE 3: from all_days >> ^ >> QUERY: >> select count(*)::numeric >> from all_days >> where (("date" between $2::date and $1::date) or ("date" between $1::date and $2::date)) >> and dow not in (0,6) >> >> CONTEXT: SQL function "bdays" during inlining
> Try to ALTER the materialized view so that it refers to "public.all_days" > rather than "all_days".
Per the error message, what needs fixing is the SQL function "bdays", not the matview as such.