From: | Jim Mercer <jim(at)reptiles(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | 7.0 weirdness (maybe solaris?) |
Date: | 2000-04-26 15:10:44 |
Message-ID: | 20000426111044.P24479@reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)reptiles(dot)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. ]
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dalphin | 2000-04-26 16:17:17 | Re: unique row identifier data type exhausted . . . |
Previous Message | Dale Anderson | 2000-04-26 15:01:33 | RE: unique row identifier data type exhausted . . . |