>>>>> "PG" == PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
PG> Given:
PG> create or replace function foo()
PG> returns text language sql
PG> as $$
PG> select current_schemas(true)::text;
PG> $$
PG> set search_path = '';
For the record, the workaround I suggested to the user on IRC who ran
into this issue was:
alter function foo() set search_path = pg_catalog;
which has (as far as I can tell) exactly the same runtime effect as
setting it to '' but doesn't break dump/restore.
--
Andrew (irc:RhodiumToad)