Thread: create database with template question
Hi, 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 i.e 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? /Dev |
On Thu, Jul 10, 2008 at 7:24 AM, Dev <dev_hyd2001@yahoo.com> wrote: > Hi, > > 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 > > i.e > > 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? expected behaviour.