port=6543
dbase=pspptest
PG_CONFIG=${PG_CONFIG:=pg_config}
-pgpath=`$PG_CONFIG | awk '/BINDIR/{print $3}'`
+pgpath=`$PG_CONFIG --bindir`
cleanup()
{
return ;
fi
PGHOST=$TEMPDIR $pgpath/pg_ctl -D $TEMPDIR/cluster stop -W -o "-k $TEMPDIR -h ''" > /dev/null 2>&1
+ cd /
rm -rf $TEMPDIR
}
activity="create database"
-createdb -h $TEMPDIR -p $port $dbase > /dev/null 2> /dev/null
+$pgpath/createdb -h $TEMPDIR -p $port $dbase > /dev/null 2> /dev/null
+if [ $? -ne 0 ] ; then no_result ; fi
activity="populate database"
-psql -h $TEMPDIR -p $port $dbase > /dev/null << EOF
+$pgpath/psql -h $TEMPDIR -p $port $dbase > /dev/null << EOF
CREATE TABLE empty (a int, b date, c numeric(23, 4));