Обсуждение: help me please

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

On Dec 28, 2007 7:01 AM, spol@mail.ru <spol@mail.ru> wrote:
> 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

pg_shadow is a view based on pg_authid. Try deleting it from
pg_authid. Note that pg_authid is defined with OIDs, which might also
be useful for you.

- Josh / eggyknap

"spol@mail.ru" <spol@mail.ru> writes:
> I have two "postgres" user. How to delete the first one ???

Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
two rows?

            regards, tom lane

"Josh Tolley" <eggyknap@gmail.com> writes:
> pg_shadow is a view based on pg_authid.

Not in 7.4 it wasn't ...

            regards, tom lane

Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one ????
thx alot for your answers.

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1;
               passwd                | ctid  | xmin |   xmax   |
cmin   | cmax
-------------------------------------+-------+------+----------+----------+-----
                      
-
                                     | (0,1) |    1 | 16754522 |
16754522 |    0
 md510db8c04d26d32185270721fcf32155 | (0,2) |    2 |        0 |        0
|    0
(2 rows)

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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         |
md510db8c04d231142d5
270721fcf740ed5 | infinity |
(2 rows)

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Tom Lane ïèøåò:
> "spol@mail.ru" <spol@mail.ru> writes:
>
>> I have two "postgres" user. How to delete the first one ???
>>
>
> Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
> two rows?
>
>             regards, tom lane
>
>
>