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: XFMail.000209141919.orsingerc@epg-gw1.lewis.army.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Responses

Browse pgsql-hackers by date

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

Browse pgsql-interfaces by date

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