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:tgl@xxxxxxxxxxxxx] Enviado el: Sunday, March 25, 2007 1:52 PM Para: Daniel Ricardo Medina CC: pgsql-admin@xxxxxxxxxxxxxx Asunto: Re: [ADMIN] URGENT TABLE PG_SHADOW CORRUTEP "Daniel Ricardo Medina" <dmedina@xxxxxxxxxxxxxxx> 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
