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
----------------------------------
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 |
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 |