"Daniel Ricardo Medina" <[EMAIL PROTECTED]> writes: > I have try to run this command in single user mod > > select * from pg_shadow; > delete from pg_shadow; > CREATE USER postgres WITH CREATEDB CREATEUSER PASSWORD '***' SYSID 1; > CREATE USER userradar PASSWORD '***'
> but the result is the same..... What do you see if you look in pg_shadow right after doing the DELETE? What PG version is this? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate