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

Re: Creating 'global' functions.

From: elein <elein(at)varlena(dot)com>
To: Matthew Jones <jonespm(at)engin(dot)umd(dot)umich(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating 'global' functions.
Date: 2004-01-31 18:33:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
If you know about these functions before
you create your databases, install them into 
template1.  Then all subsequently created databases
will have them.

If the databases already exist, you need to do what you did.

elein(at)varlena(dot)com        Varlena, LLC

          PostgreSQL Consulting, Support & Training   

PostgreSQL General Bits
Its a doggy dog world out there.

On Mon, Jan 26, 2004 at 04:40:33PM -0500, Matthew Jones wrote:
> Is there a way, when a function is created (in language SQL for example),
> for it to be available globally, as the pg_catalog functions are. All of
> the ones I create are only available on the database they were created,
> and I can't figure out a way to make it so they're available to all
> without having to run the functions in every database. When you run a
> select on pg_proc they won't even appear, but all of the 'catalog' ones
> will.
> These are generic cast functions that needed to be written when we
> migrated from 7.2 to 7.3, so they don't reference any specific database
> tables or anything like that, but all of the databases NEED these
> functions to operate the way the queries were written. I tried to change
> the proowner and pronamespace in pg_proc and these didn't seem to do
> anything.
> I worked with this a few days with no luck at all, and just ended up
> running the creation scripts in all of our databases, but it would be nice
> to know if it's possible.
> Thanks!
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

In response to

pgsql-general by date

Next:From: Sally SallyDate: 2004-01-31 18:52:06
Subject: Separating a single database into different disks
Previous:From: Tom LaneDate: 2004-01-31 17:27:49
Subject: Re: Executing a query and returning the result set using the SPI

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