Re: BUG #12465: Materialized view dump restoration issue

I see what you mean.  I ran across this issue with
ST_AsLatLonText(geometry) in PostGIS (which calls ST_AsLatLonText(geometry,
text)).  I'll pass this bug on to them.

Jeff

On Fri, Jan 9, 2015 at 3:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> jeff.casavant@gmail.com writes:
> > 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();
>
> This is not a pg_dump bug, this is a broken definition of function a().
> That function will fail in any context where the caller changes
> search_path, not only pg_dump.  You can perhaps get away without that
> in a single-schema database, but not with multiple schemas.
>
> You could fix it by schema-qualifying b in the text of a,
> or by adding a "SET schema_path" clause to a.
>
>                         regards, tom lane
>