I have a database with a table and some triggers and functions set on it. I converted it into a template setting the fields datallowcon=false and datistemplate=true on it. Lets assume this template(database) is called as mytemplate.
Now, as a normal database user I issue the create database command and specify mytemplate
create database testdb template mytemplate;
Everything works fine except that the table in the newly created testdb is still the user postgres, the one who created the template database.
Is this expected behavior or am I missing something?
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2008-07-10 14:33:17|
|Subject: Re: create database with template question|
|Previous:||From: Julius Tuskenis||Date: 2008-07-10 10:39:05|
|Subject: Re: query optimization|