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.klaver@xxxxxxxxxxx