U=`whoami`

U=regression

export LC_ALL=C

export LANGUAGE="en_US:en"

remoteSrvName=fdwremote

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH

export PATH=$PGINSTALL/bin:$PATH

export PGDATABASE=regression

pkill -9 postgres||true

sleep 1

createdb -p 5432$U

psql -p 5432 -c"CREATE EXTENSION postgres_fdw;"

psql -p 5432 -c"CREATE SERVER$remoteSrvName FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '5433', use_remote_estimate 'on');"

psql -p 5432 -c"CREATE SERVER$remoteSrvName FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '5433',dbname 'regression',use_remote_estimate 'on');"

psql -p 5432 -c"CREATE USER MAPPING FOR PUBLIC SERVER$remoteSrvName;"

cp`pwd`/src/test/regress/regress.so$PGINSTALL/lib

cp`pwd`/src/test/regress/regress.so$PGINSTALL/lib/postgresql/

cd src/test/regress

./pg_regress --schedule=$SCRIPTS/serial_schedule --load-extension=postgres_fdw --load-extension=pg_execplan --load-extension=pg_repeater --dbname=andrey --use-existing

./pg_regress --schedule=$SCRIPTS/serial_schedule --load-extension=postgres_fdw --load-extension=pg_execplan --load-extension=pg_repeater --dbname=regression --use-existing

psql -p 5432 -c"SELECT pg_store_query_plan('../test.txt', 'SELECT id ### 1 FROM tests.ttest1;');"

psql -p 5433 -c"SELECT pg_exec_stored_plan('../test.txt');"

psql -p 5432 -c"CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');"

psql -p 5432 -c"CREATE TABLE person ( name text, current_mood mood);"

psql -p 5433 -c"CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');"

psql -p 5433 -c"CREATE TABLE person ( name text, current_mood mood);"

psql -p 5432 -c"SELECT pg_store_query_plan('../test.txt', 'INSERT INTO person VALUES (''Moe'', ''happy'');');"

psql -p 5432 -c"SELECT pg_exec_stored_plan('../test.txt');"

psql -p 5433 -c"SELECT pg_exec_stored_plan('../test.txt');"

psql -p 5432 -c"SELECT * FROM person WHERE current_mood = 'happy';"

psql -p 5433 -c"SELECT * FROM person WHERE current_mood = 'happy';"