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

RE: [INTERFACES] The persistance of C functions

From: Craig Orsinger <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: RE: [INTERFACES] The persistance of C functions
Date: 2000-02-09 22:19:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-interfaces
On 09-Feb-00 Bryan White wrote:
> If I use CREATE FUNCTION for a C function in a .so file and then use the
> function and then change and recompile the function, what steps are needed
> to see the change?
> As I see it the options are:
> A: do nothing, the function is reloaded on every invocation.
> B: Reopen the connection to the backend
> C: Restart the postmaster
> I suspect B is correct but I would like to hear someone confirm it.

        I don't know about A or B, but C definitely works :-). If it's
practical, I sometimes use DROP FUNCTION/CREATE FUNCTION, but I don't
think this is practical when you're using this function (or set of 
functions) to implement a new data type.

Date: 09-Feb-00  Time: 14:16:54

Craig Orsinger                  (email: <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor

In response to


pgsql-hackers by date

Next:From: Chris BitmeadDate: 2000-02-09 22:32:00
Subject: Re: [HACKERS] backend startup
Previous:From: Bryan WhiteDate: 2000-02-09 21:31:14
Subject: The persistance of C functions

pgsql-interfaces by date

Next:From: Ken J. WrightDate: 2000-02-09 23:17:31
Subject: Re: [INTERFACES] jdbc question
Previous:From: LarsDate: 2000-02-09 21:34:38
Subject: Re: [INTERFACES] jdbc question

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