I didn’t realize that pg_dump alters the search path. Couldn’t pg_dump simply append the default search path to the end
ofit’s custom setting? That should solve the problem as well? We have not changed our search path and it seems the
defaultis “$user”, public.
Jeremy Cowgar
> On May 12, 2017, at 2:50 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Jeremy Cowgar <jeremy@cowgar.com> writes:
>> Why does it find the initial function just fine in the public namespace, but the method it calls it can not find,
whichis in the same namespace as the calling function?
>
> pg_dump is smart enough to schema-qualify that one. If you look at
> the actual dump output for the table, it looks like
>
> SET search_path = g, pg_catalog;
> ...
> CREATE TABLE people (
> id integer NOT NULL,
> name character varying(50) NOT NULL,
> CONSTRAINT people_name_check CHECK (public.has_content((name)::text))
> );
>
> However, editing the body text of your function is beyond pg_dump's
> competence.
>
> 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