Thread: help me plz with 2 postgres users

Hello?
help me plz? i don't khow what to do...

How can I delete first postgres user.

template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from
pg_shadow where usesysid=1;
usename  |               passwd                | valuntil | ctid  | xmin
|   xmax   |   cmin   | cmax
----------+-------------------------------------+----------+-------+------+----------+----------+------

postgres |                                     |          | (0,1) |    1
| 16754522 | 16754522 |    0
postgres | md65476547442532.. | infinity | (0,2) |    2 |        0
|        0        |    0
(2 rows)

thx for your help.
Oleg

spol@mail.ru wrote:

> How can I delete first postgres user.
>
Ugh. How did you duplicate if there is an unique index in rolname ?
pg_shadow is a view; you want to take a look  at the real relation
pg_authid.

delete from pg_authid where ctid = '(0,1)'


--
   Euler Taveira de Oliveira
   http://www.timbira.com/

spol@mail.ru wrote:
> Hello?
> help me plz? i don't khow what to do...
>
> How can I delete first postgres user.
>
> template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax
> from pg_shadow where usesysid=1;
> usename  |               passwd                | valuntil | ctid  |
> xmin |   xmax   |   cmin   | cmax
> ----------+-------------------------------------+----------+-------+------+----------+----------+------
>
> postgres |                                     |          | (0,1) |
> 1 | 16754522 | 16754522 |    0
> postgres | md65476547442532.. | infinity | (0,2) |    2 |
> 0       |        0        |    0
> (2 rows)
>
> thx for your help.
> Oleg
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Hola, no se me ocurre como ayudarte pero podrias hace asi la consulta:
select usename||'-',passwd,valuntil,ctid,xmin,xmax,cmin,cmax from
pg_shadow where usesysid=1;

Que version de postgres estas usando?