Re: NewB question wrt Create Database

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match