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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
