i've got 7.0RC1 running on a solaris7 box.
i'm running into some problems using the bin scripts.
for example, with destroyuser, we have:
PARGS="-tq $AUTHOPT $PGHOSTOPT $PGPORTOPT"
PSQL="psql $PARGS"
QUERY="select usesuper from pg_user where usename = '$USER'"
ADDUSER=`$PSQL -c "$QUERY" template1`
if [ x$ADDUSER != xt ]
then
echo "$CMDNAME: $USER cannot delete users."
exit 1
fi
when i run: "sh -x destroyuser username" i get:
PSQL=psql -tq
QUERY=select usesuper from pg_user where usename = 'pgsql'
+ psql -tq -c select usesuper from pg_user where usename = 'pgsql' template1
ADDUSER= t
+ [ 0 -ne 0 ]
+ [ x t != xt ]
destroyuser: test: unknown operator t
it appears that the psql client on this machine is prepending a space to the
output of selects.
is this a command line option, a compiler option, a bug?
--
[ Jim Mercer jim@reptiles.org +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]