help me plz with 2 postgres users

From: "spol(at)mail(dot)ru" <spol(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: help me plz with 2 postgres users
Date: 2008-02-26 11:25:19
Message-ID: 47C3F71F.5050501@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zdenek Kotala 2008-02-26 12:55:19 Re: BUG #3991: pgsql function sum()
Previous Message mirek 2008-02-26 10:25:34 BUG #3991: pgsql function sum()