"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
