470,647 Members | 1,099 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

create template database

I'm trying to create a template database as a superuser. I set the
value in pg_database datistemplate to 't'. But when I create a
database as another user i don't have any priviliges on the tables in
the new database. So I granted ALL to PUBLIC on the tables in the
template database. Now when I create a database with the new template
I can use it, but the tables are still owned by the user that created
(owns) the template.

Is there anything i need to do to make the template a true template, I
mean, that it behaves in the same way as template1?

GreetZ, Sam

ps: A happy new year to you all!
Jul 19 '05 #1
0 1927

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Sam | last post: by
7 posts views Thread by pintihar | last post: by
9 posts views Thread by Brian Kitt | last post: by
reply views Thread by Dino Buljubasic | last post: by
15 posts views Thread by lxyone | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.