Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Mark DalphinDate: 2000-04-26 16:17:17
Subject: Re: unique row identifier data type exhausted . . .
Previous:From: Dale AndersonDate: 2000-04-26 15:01:33
Subject: RE: unique row identifier data type exhausted . . .

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group