From: | Kanitchet Vaiassava <kanichet(at)hotmail(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Cc: | "Kanitchet Vaiassava" <kanitchet(dot)vai(at)thaiace(dot)co(dot)th>, "Kanitchet Vaiassava" <kanichet(at)hotmail(dot)com> |
Subject: | |
Date: | 2014-04-05 13:17:00 |
Message-ID: | SNT404-EAS4017D58F93B244AAE657A52D86E0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
PostgreSQL 9.3.3
Microsoft Windows Server 2012 x64
I found that when I restored dumped database to another server.
The restoration process (by pg_restore) was
error at REFRESH MATERIALIZED VIEW's command and it noticed that "ERROR:
function that materialized view used does not exists."
However, the function is exits but in another schema (the materialized view
that occurred error is in schema name "account", the function is in schema
"public") and I found that if Materialized view and function are in the same
schema .. no problem and after restoration process is finished.
I ran REFRESH MATERIALIZED VIEW's at pgAdmin's SQL editor .. no problem.
So, I think the restoration process does not support when Materialized view
and function are not in the same schema.
Sorry for very bad English Gramma.
Thank you
Attachment | Content-Type | Size |
---|---|---|
![]() |
image/png | 35.6 KB |
![]() |
image/png | 38.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-04-05 15:06:37 | Re: |
Previous Message | jfneiraf | 2014-04-05 05:47:09 | BUG #9867: ERROR INSTALATION |