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

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

pgsql-bugs by date

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

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