Re: help me plz with 2 postgres users

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: "spol(at)mail(dot)ru" <spol(at)mail(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: help me plz with 2 postgres users
Date: 2008-02-26 16:45:32
Message-ID: 47C4422C.5010500@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

spol(at)mail(dot)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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Faheem Mitha 2008-02-26 16:47:22 Re: BUG #3968: ssh tunnel instructions could use improvement
Previous Message Peter Eisentraut 2008-02-26 16:07:26 Re: BUG #3968: ssh tunnel instructions could use improvement