[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
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
--
