The following bug has been logged on the website:
Bug reference: 12465
Logged by: Jeff Casavant
Email address: jeff.casavant@gmail.com
PostgreSQL version: 9.4.0
Operating system: Ubuntu 14.04.1
Description:
If
- two functions A and B exist in the public schema
- A calls B, and
- a materialized view calls A
then the dump produced by pg_dump or pg_dumpall will throw the following
error when passed to psql -f:
psql:dump.sql:7730: ERROR: function b() does not exist
LINE 1: SELECT B()
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
QUERY: SELECT B()
CONTEXT: SQL function "b" during inlining
Code to reproduce:
create function b() returns int as $$ select 1 $$ language sql;
create function a() returns int as $$ select b() $$ language sql;
create schema qwr;
create materialized view qwr.c as select a();
Then run pg_dump | psql .
Workaround:
Add public to all calls to 'SET search_path' in the dump.
