# this script assumes that the current user can connect without
# being prompted for a password


for i in 0 1 ; do
echo "** test when i = $i"
  createuser -A -D louser1 

  createdb lotestdb1

  TESTF=/tmp/pgtest$$
  cat >> $TESTF <<EOF
This is just a simple little file
EOF
  if [ 0 == $i ] ; then 
    psql lotestdb1 louser1 -c "create table z (bah int);"
  fi
  psql lotestdb1 louser1 -c "\lo_import $TESTF";
  pg_dump --blobs --format=c --quotes --oids --compress=5 lotestdb1 > /tmp/lotestdb1.dump
  psql template1 -c "drop database lotestdb1;"
  createdb lotestdb1
  pg_restore -d lotestdb1 < /tmp/lotestdb1.dump

  ## cleanup

  rm $TESTF
  rm /tmp/lotestdb1.dump

  dropdb lotestdb1

  dropuser louser1
done
