On Thu, Mar 10, 2016 at 3:21 AM, Regina Obe <l...@pcorp.us> wrote: > When you back up the database, it would create a backup with this line: > > SET search_path = public, pg_catalog; > --your create materialized view here > > When you restore even if your database has search_paths set, your > materialized view will not come back and will error out with: > > ERROR: function _helper(box, box) does not exist > LINE 2: SELECT $1 && $2 AND _helper($1,$2) = 0; > ^ > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. > QUERY: > SELECT $1 && $2 AND _helper($1,$2) = 0;
Hmm. The meaning of funcs.inline depends on the search_path, not just during dump restoration but all the time. So anything uses it under a different search_path setting than the normal one will have this kind of problem; not just dump/restore. I don't have a very good idea what to do about that. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
