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

Re: Persistent user-defined functions

From: Felipe de Jesús Molina Bravo <felipe(dot)molina(at)inegi(dot)gob(dot)mx>
To: David T <intrepid__x(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Persistent user-defined functions
Date: 2008-03-28 15:32:45
Message-ID: 1206718365.4347.2.camel@fjmb (view raw or flat)
Thread:
Lists: pgsql-general
if you create its in a template1 .... 

regards...
El jue, 27-03-2008 a las 23:10 -0400, David T escribió:
> Hi all,
> 
> I am using Ubuntu 7.10 with PostgreSQL 8.2.  I have just finished creating two C functions and have successfully loaded them using "CREATE OR REPLACE FUNCTION" ... This was an extremely smooth process, and I have a lot of respect for the dev team for creating such a robust system.
> 
> Anyway - I would like these new functions to be permanently available to a database, or to all databases.  These functions will ultimately be called from PHP, where there is no guarantee of server state in between requests (maybe a reboot occurs and my functions are lost, etc...).  On the other hand, it is inefficient to "CREATE OR REPLACE" all the time.  Can anybody suggest a lightweight method to keep these functions permanently available, or point me towards a resource that might assist?
> 
> Best regards,
> 
> Dave.
> _________________________________________________________________
> This Valentine's Day, get creative and show your sweetheart how much you care with flair! Find fun date ideas here!
> http://g.msn.ca/ca55/224

In response to

pgsql-general by date

Next:From: JackpipEDate: 2008-03-28 15:33:44
Subject: pg_stat_user_tables
Previous:From: pgsql-general-ownerDate: 2008-03-28 15:29:45
Subject: [pgsql-general] Daily digest v1.8037 (17 messages)

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