Re: Schema authorization after create database.

Поиск
Список
Период
Сортировка
От Tsirkin Evgeny
Тема Re: Schema authorization after create database.
Дата
Msg-id 411B4EDA.1080308@mail.jct.ac.il
обсуждение исходный текст
Ответ на Re: Schema authorization after create database.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: eko oke
Дата:
Сообщение: user postgres
Следующее
От: "D Kavan"
Дата:
Сообщение: Re: pg_restore