From: Jason Etheridge <jason@esilibrary.com>
Date: Tue, 8 Aug 2017 14:29:04 +0000 (-0400)
Subject: mig-env: set PGOPTIONS for search_path
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=2da015ea87a2a2a922729cb5ed83d529c4a36aa0

mig-env: set PGOPTIONS for search_path

Signed-off-by: Jason Etheridge <jason@esilibrary.com>
---

diff --git a/mig-bin/mig-env b/mig-bin/mig-env
index eddfc27..bcfe148 100755
--- a/mig-bin/mig-env
+++ b/mig-bin/mig-env
@@ -227,6 +227,7 @@ sub mig_env_create {
     print FILE "export PGPORT=$PGPORT\n";
     print FILE "export PGDATABASE=$PGDATABASE\n";
     print FILE "export PGUSER=$PGUSER\n";
+    print FILE "export PGOPTIONS='-c search_path=$migration_schema,public,evergreen'\n";
     print FILE "export MIGENVPROMPT=$migration_schema\n";
     print FILE "export MIGSCHEMA=$migration_schema\n";
     print FILE "export MIGBASEWORKDIR=$MIGBASEWORKDIR\n";