Re: NewB question wrt Create Database

[Guillaume Lelarge <guillaume(at)lelarge(dot)info>]

Hi,

Josh wrote:
> I have a question about the behavior of PGAdmin (or perhaps this is PG) 
> in creating databases.
>
> If I create a DB while logged in as postgres, and indicate the database 
> owner is another login role, then PG creates the database with that 
> login role being the owner but everything within the db is owned by 
> Postgres. So, for example, I can't go start creating tables and such as 
> the login role because that role does not own the public schema.
>
> Why does it behave in this way?

It doesn't behave like this for me. Which PostgreSQL release do you use 
? did you try the same thing with psql or phppgadmin ?


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com