| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Nicola Contu <nicola(dot)contu(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net> |
| Subject: | Re: Restore from dumps |
| Date: | 2018-07-25 14:28:45 |
| Message-ID: | 1735.1532528925@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicola Contu | 2018-07-25 14:33:25 | Re: Restore from dumps |
| Previous Message | Fabio Pardi | 2018-07-25 13:48:32 | Re: DB Backup from WAL Slave |