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 <tgl@xxxxxxxxxxxxx>:
Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
