2 # $Header: /cvsroot/pgsql/src/test/regress/Attic/regress.sh,v 1.5 1997/04/05 21:24:11 scrappy Exp $
8 TZ="PST8PDT"; export TZ
11 FRONTEND="psql -n -e -q"
13 echo =============== destroying old regression database... =================
16 echo =============== creating new regression database... =================
23 #$FRONTEND regression < create.sql
24 #if [ $? -ne 0 ]; then
25 # echo the creation script has an error
29 echo =============== running regression queries ... =================
30 for i in `cat sql/tests`
33 $FRONTEND regression < sql/${i}.sql > results/${i}.out 2>&1
34 if [ `diff expected/${i}.out results/${i}.out | wc -l` -ne 0 ]
42 $FRONTEND regression < queries.sql
43 # this will generate error result code
45 echo =============== running error queries ... =================
46 $FRONTEND regression < errors.sql
47 # this will generate error result code
49 #set this to 1 to avoid clearing the database
52 if test "$debug" -eq 1
54 echo Skipping clearing and deletion of the regression database
56 echo =============== clearing regression database... =================
57 $FRONTEND regression < destroy.sql
59 echo the destroy script has an error
64 echo =============== destroying regression database... =================