After delete all, postgres said no exist the user id 1...
The version is 7.4.8 Daniel Ricardo Medina Ing. de Desarrollo Computec S.A. Tel 260 71 11 Ext 1640 -----Mensaje original----- De: Tom Lane [mailto:[EMAIL PROTECTED] Enviado el: Sunday, March 25, 2007 1:52 PM Para: Daniel Ricardo Medina CC: pgsql-admin@postgresql.org Asunto: Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP "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 4: Have you searched our list archives? http://archives.postgresql.org
