Re: Postgres db corrupted ?

"Tom Lane" <tgl@sss.pgh.pa.us>
> "Mendola Gaetano" <mendola@bigfoot.com> writes:
> >  ""John P. Looney"" <valen@tuatha.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@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@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@XXX [] > psql -l | grep jfk
 db_jfk                       | jfk       | SQL_ASCII
kalman@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@XXX [] > psql -l | grep jfk
 db_jfk                       |           | SQL_ASCII




Regards
Gaetano