Skip site navigation (1) Skip section navigation (2)

Re: Global / cluster-wide functions

From: Chander Ganesan <chander(at)otg-nc(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: kevin kempter <kevin(at)kevinkempterllc(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Global / cluster-wide functions
Date: 2008-05-19 15:07:58
Message-ID: 483197CE.7090706@otg-nc.com (view raw or flat)
Thread:
Lists: pgsql-admin
Joshua D. Drake wrote:
> On Fri, 16 May 2008 15:12:02 -0600
> kevin kempter <kevin(at)kevinkempterllc(dot)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.

In response to

pgsql-admin by date

Next:From: Peter KoczanDate: 2008-05-19 19:04:40
Subject: old, dead connections?
Previous:From: Glyn AstillDate: 2008-05-19 11:03:28
Subject: Re: pg_restore test procedures (a bit OT)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group