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: | 2007-12-28 14:01:47 |
Message-ID: | 477501CB.5010506@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Tolley | 2007-12-28 15:09:35 | Re: help me please |
Previous Message | Kevin Grittner | 2007-12-27 23:16:30 | Re: BUG #3822: Nonstandard precedence for comparison operators |