Joshua D. Drake wrote: > I probably shouldn't be answering this at two in the morning but... As I > understand it in a hosted environment it is quite common that a > superuser will do this: > > create database foo owner foo; > > Database foo would get plpgsql (as would user foo) at that point > because template1 had plpgsql.
I'm not seeing the benefit: alvherre=# create user plpg; CREATE ROLE alvherre=# create database plpg owner plpg; CREATE DATABASE alvherre=# \c plpg plpg Vous êtes maintenant connecté à la base de données « plpg »comme utilisateur « plpg ». plpg=> create language plpgsql; CREATE LANGUAGE plpg=> Yes, this is new in 8.3. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings