Re: Postgres db corrupted ?

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> "Mendola Gaetano" <mendola(at)bigfoot(dot)com> writes:
> > ""John P. Looney"" <valen(at)tuatha(dot)org> writes:
> >> bbadmin | | SQL_ASCII
>
> > For sure a way to obtain this inconsistence is delete the owner of
> > a db and voila' a DB result to have no owner.
>
> Nope. I don't know how John got into this state, but it most definitely
> was not that way. Try it.

Here it his:

kalman(at)XXX [] > createuser jfk
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
kalman(at)XXX [] > psql -U jfk template1
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

template1=# create database db_jfk;
CREATE DATABASE
template1=# \q
kalman(at)XXX [] > psql -l | grep jfk
db_jfk | jfk | SQL_ASCII
kalman(at)XXX [] > psql template1
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

template1=# delete from pg_shadow where usename = 'jfk';
DELETE 1
template1=# \q
kalman(at)XXX [] > psql -l | grep jfk
db_jfk | | SQL_ASCII

Regards
Gaetano