Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Josh TolleyDate: 2007-12-28 15:09:35
Subject: Re: help me please
Previous:From: Kevin GrittnerDate: 2007-12-27 23:16:30
Subject: Re: BUG #3822: Nonstandard precedence for comparisonoperators

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group