7.0 weirdness (maybe solaris?)

Поиск
Список
Период
Сортировка
От Jim Mercer
Тема 7.0 weirdness (maybe solaris?)
Дата
Msg-id 20000426111044.P24479@reptiles.org
обсуждение исходный текст
Ответы Re: [HACKERS] 7.0 weirdness (maybe solaris?)
Список 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@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.  ]

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dale Anderson"
Дата:
Сообщение: RE: unique row identifier data type exhausted . . .
Следующее
От: Ed Loehr
Дата:
Сообщение: Re: Revisited: Transactions, insert unique.