help me please

Поиск
Список
Период
Сортировка
От spol@mail.ru
Тема help me please
Дата
Msg-id 477501CB.5010506@mail.ru
обсуждение исходный текст
Ответы Re: help me please  ("Josh Tolley" <eggyknap@gmail.com>)
Re: help me please  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
hello

Help me please...
I have two "postgres" user. How to delete the first one ???

*******************
# select * from pg_shadow where usesysid=1;
 usename  | usesysid | usecreatedb | usesuper | usecatupd
|               passwd                | valuntil | useconfig
----------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
 postgres |        1 | t           | t        | t
|                                     |          |
 postgres |        1 | t           | t        | t         |
md53532747417351142d5270721fcf740ed5 | infinity |
(2 rows)
*******************

*******************
# select * from pg_user where usesysid=1;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |        1 | t           | t        | t         | ********
|          |
 postgres |        1 | t           | t        | t         | ******** |
infinity |
(2 rows)
*******************


I tried
    delete from pg_shadow where passwd is null;

but it's not working.

Help me please
oleg

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #3822: Nonstandard precedence for comparison operators
Следующее
От: "Josh Tolley"
Дата:
Сообщение: Re: help me please