Create db with template does not transfer ownership

Поиск
Список
Период
Сортировка
От Ben Harper
Тема Create db with template does not transfer ownership
Дата
Msg-id 6def3e7b0906290550v481994f4if78bd8b95839cef2@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
I'm trying to create a PostGIS database by using

CREATE DATABASE mydb TEMPLATE template_postgis;

using the Windows one-click installer package, with PostGIS 1.3 /
Postgres 8.3.7.

But my question is more general:
When a new database is created base on a template, the owner of those
tables is not changed. The owner of the copied tables remains the
original owner in the template. This leaves the owner of the new DB
unable to access those tables. The end result is that you cannot use a
system-wide template database, unless you want to grant full access to
these tables. Should the action of the 'TEMPLATE' option not be to
transfer ownership to the owner of the new DB? I don't understand how
one is supposed to use this mechanism.

Thanks,
Ben

В списке pgsql-general по дате отправления:

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: Replication and coding good practices
Следующее
От: durumdara
Дата:
Сообщение: Am I in intransaction or in autocommit mode?