6 echo "**** Destroy old database $DBNAME ****"
11 echo "**** Create test database $DBNAME ****"
12 createdb $DBNAME || exit 1
14 echo "**** Create procedural language pltcl ****"
15 createlang pltcl $DBNAME || exit 1
17 echo "**** Create tables, functions and triggers ****"
18 psql -q -n $DBNAME <test_setup.sql
20 echo "**** Running test queries ****"
21 psql -q -n -e $DBNAME <test_queries.sql > test.out 2>&1
23 if diff test.expected test.out >/dev/null 2>&1 ; then
24 echo " Tests passed O.K."
27 echo " Tests failed - look at diffs between"
28 echo " test.expected and test.out"