Thread: Global / cluster-wide functions
Hi List; Can I install a PL/pgSQL function so it's global to all databases within a cluster or do I need to install per database ? Thanks in advance
On Fri, 16 May 2008 15:12:02 -0600 kevin kempter <kevin@kevinkempterllc.com> wrote: > Hi List; > > Can I install a PL/pgSQL function so it's global to all databases > within a cluster or do I need to install per database ? > Install it into template1 then each database created after that will have the function. Joshua D. Drake > > Thanks in advance > -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Attachment
Joshua D. Drake wrote:
As a corollary to that, you'll need to create the function in all existing databases, since changes to the template database only apply to new databases.
On Fri, 16 May 2008 15:12:02 -0600 kevin kempter <kevin@kevinkempterllc.com> wrote:Hi List; Can I install a PL/pgSQL function so it's global to all databases within a cluster or do I need to install per database ?Install it into template1 then each database created after that will have the function.
As a corollary to that, you'll need to create the function in all existing databases, since changes to the template database only apply to new databases.
-- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 919-463-0999/877-258-8987 http://www.otg-nc.com Ask me about OTG's expert PostgreSQL, PostGIS, and other Open Source training offerings.