| 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: | Whole Thread | Raw Message | 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 |