On 2018-Jul-18, firstname lastname wrote:
> Peter,
>
> Both of your suggestions work. I opted to change the search path in
> the dump file. The alternative is is to prefix "public" to hundreds
> of functions. I do not want to do that. Too much work.
Hmm, surely you can just do "ALTER FUNCTION ... SET search_path" in a DO
block that processes all functions, or something to that effect.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services