On 7/9/19 6:28 AM, Ron wrote:


Then should search_path be set at the end of pg_restore?


1) That would be to late for anything happening in the restore.

2) The:

SELECT pg_catalog.set_config('search_path', '', false);

only applies to the restore session. After the restore the search_path will return to whatever has been configured.



--
Adrian Klaver
adrian.kla...@aklaver.com


Reply via email to