help me please
- From: "spol(at)mail(dot)ru" <spol(at)mail(dot)ru>
- To: pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Subject: help me please
- Date: Fri, 28 Dec 2007 17:01:47 +0300
- Message-id: <477501CB.5010506@mail.ru> <text/plain>
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
Home |
Main Index |
Thread Index