Re: Persistent user-defined functions - Mailing list pgsql-general

From Felipe de Jesús Molina Bravo
Subject Re: Persistent user-defined functions
Date
Msg-id 1206718365.4347.2.camel@fjmb
Whole thread Raw
In response to Persistent user-defined functions  (David T <intrepid__x@hotmail.com>)
List 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
loadedthem using "CREATE OR REPLACE FUNCTION" ... This was an extremely smooth process, and I have a lot of respect for
thedev 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
functionswill ultimately be called from PHP, where there is no guarantee of server state in between requests (maybe a
rebootoccurs 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
resourcethat 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

pgsql-general by date:

Previous
From: "Dawid Kuroczko"
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Next
From:
Date:
Subject: Re: Users, groups and inheritance questions