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

Re: [INTERFACES] The persistance of C functions

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] The persistance of C functions
Date: 2000-02-09 23:42:16
Message-ID: 011d01bf7357$4c52b160$ (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
> > 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.

Thanks, I have come to the conclusion that B is sufficient based on trial
and error.

In response to

pgsql-hackers by date

Next:From: Alfred PerlsteinDate: 2000-02-09 23:44:22
Subject: Re: [HACKERS] TODO item
Previous:From: Bruce MomjianDate: 2000-02-09 23:28:10
Subject: Re: [HACKERS] TODO item

pgsql-interfaces by date

Next:From: Bryan WhiteDate: 2000-02-09 23:45:37
Subject: How to get remote ip address is stored proceedure
Previous:From: Ken J. WrightDate: 2000-02-09 23:17:31
Subject: Re: [INTERFACES] jdbc question

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