"Tom Lane" <[EMAIL PROTECTED]>
> "Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> > ""John P. Looney"" <[EMAIL PROTECTED]> 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:
[EMAIL PROTECTED] [] > 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
[EMAIL PROTECTED] [] > 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
[EMAIL PROTECTED] [] > psql -l | grep jfk
db_jfk | jfk | SQL_ASCII
[EMAIL PROTECTED] [] > 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
[EMAIL PROTECTED] [] > psql -l | grep jfk
db_jfk | | SQL_ASCII
Regards
Gaetano
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
