From: Chander Ganesan <chander@otg-nc.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: kevin kempter <kevin@kevinkempterllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Global / cluster-wide functions
Date: Mon, 19 May 2008 11:07:58 -0400
Message-ID: <483197CE.7090706@otg-nc.com> (raw)
In-Reply-To: <20080516142530.0ba81186@jd-laptop>
References: <EB01C44C-1EEA-4F1F-BA38-6A9B21C4F410@kevinkempterllc.com>
<20080516142530.0ba81186@jd-laptop>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chander@otg-nc.com, jd@commandprompt.com, kevin@kevinkempterllc.com
Subject: Re: Global / cluster-wide functions
In-Reply-To: <483197CE.7090706@otg-nc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox