2 # $Header: /cvsroot/pgsql/src/test/regress/Attic/regress.sh,v 1.6 1997/04/06 08:53:34 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 echo =============== running regression queries ... =================
24 for i in `cat sql/tests`
27 $FRONTEND regression < sql/${i}.sql > results/${i}.out 2>&1
28 if [ `diff expected/${i}.out results/${i}.out | wc -l` -ne 0 ]
37 echo =============== running error queries ... =================
38 $FRONTEND regression < errors.sql
39 # this will generate error result code
41 #set this to 1 to avoid clearing the database
44 if test "$debug" -eq 1
46 echo Skipping clearing and deletion of the regression database
48 echo =============== clearing regression database... =================
49 $FRONTEND regression < destroy.sql
51 echo the destroy script has an error
56 echo =============== destroying regression database... =================