Re: Schema authorization after create database.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ian FREISLICH <if(at)hetzner(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Schema authorization after create database.
Date: 2005-08-11 14:08:59
Message-ID: 21954.1123769339@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ian FREISLICH <if(at)hetzner(dot)co(dot)za> writes:
> I ran into this little astonishment yesterday on 7.4.8. When I
> create a database connected as the super user using:

> CREATE DATABASE foo OWNER = foo;

> The database is indeed owned by user foo, but the automatically
> created public schema is is owned by the database super user. Should
> this schema not be created as owned by the database owner specified
> in the CREATE DATABASE command?

That's the way it's supposed to work. CREATE DATABASE does not change
anything inside the copied database.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2005-08-11 17:00:04 Re: Problem in restore data
Previous Message Tom Lane 2005-08-11 14:07:33 Re: restoring an old database to a new instance -- possible ?