7.0 weirdness (maybe solaris?)

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. ]

Responses

Browse pgsql-general by date

  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 . . .