pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
2+ messages / 2 participants
[nested] [flat]
* (no subject)
@ 2014-04-05 13:17 Kanitchet Vaiassava <kanichet@hotmail.com>
2014-04-05 15:06 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Kanitchet Vaiassava @ 2014-04-05 13:17 UTC (permalink / raw)
To: pgsql-bugs; +Cc: Kanitchet Vaiassava <kanitchet.vai@thaiace.co.th>; Kanitchet Vaiassava <kanichet@hotmail.com>
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Attachments:
restore_error_notice.png (image/png, 35.6K) download
view image
restore_error_command.png (image/png, 38.2K) download
view image
* Re:
2014-04-05 13:17 (no subject) Kanitchet Vaiassava <kanichet@hotmail.com>
@ 2014-04-05 15:06 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2014-04-05 15:06 UTC (permalink / raw)
To: Kanitchet Vaiassava <kanichet@hotmail.com>; +Cc: pgsql-bugs@postgresql.org, "Kanitchet Vaiassava" <kanitchet.vai@thaiace.co.th>
Kanitchet Vaiassava <kanichet@hotmail.com> writes:
> So, I think the restoration process does not support when Materialized view
> and function are not in the same schema.
Could you show us a self-contained test case for this problem? That is,
a SQL script that creates a database that doesn't dump and restore
properly?
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-04-05 15:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-04-05 13:17 Kanitchet Vaiassava <kanichet@hotmail.com>
2014-04-05 15:06 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox