Re: BUG #15101: function set search_path = '' breaks dump/restore

>>>>> "PG" == PG Bug reporting form <noreply@postgresql.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)