That worked. Thanks guys. 2018-07-25 16:33 GMT+02:00 Nicola Contu <nicola.co...@gmail.com>:
> yeah, we updated that function in production to says public.all_days. > I will let you know at the next restore. > > Thanks guys, appreciated. > > 2018-07-25 16:28 GMT+02:00 Tom Lane <t...@sss.pgh.pa.us>: > >> Laurenz Albe <laurenz.a...@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. >> >> regards, tom lane >> > >