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: 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

Responses

Browse pgsql-bugs by date

  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