Re: Schema authorization after create database. - Mailing list pgsql-admin

From Tsirkin Evgeny
Subject Re: Schema authorization after create database.
Date
Msg-id 411B4EDA.1080308@mail.jct.ac.il
Whole thread Raw
In response to Re: Schema authorization after create database.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Yep.But this is a little strange ,maybe we should ask to change it?
Evgeny.
Tom Lane wrote:
> Ian FREISLICH <if@hetzner.co.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


pgsql-admin by date:

Previous
From: eko oke
Date:
Subject: user postgres
Next
From: "D Kavan"
Date:
Subject: Re: pg_restore