"Daniel Ricardo Medina" <dmedina(at)computec(dot)com(dot)co> 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
In response to
pgsql-admin by date
|Next:||From: Peter Koczan||Date: 2007-03-26 00:27:56|
|Subject: Re: URGENT TABLE PG_SHADOW CORRUTEP|
|Previous:||From: Daniel Ricardo Medina||Date: 2007-03-25 02:56:56|
|Subject: URGENT TABLE PG_SHADOW CORRUTEP|