Thread: Global / cluster-wide functions

Global / cluster-wide functions

From
kevin kempter
Date:
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

Re: Global / cluster-wide functions

From
"Joshua D. Drake"
Date:
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

Re: Global / cluster-wide functions

From
Chander Ganesan
Date:
Joshua D. Drake wrote:
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.