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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> jeff(dot)casavant(at)gmail(dot)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
>