On Wed, 9 Feb 2000, 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.
'B' is right - the postgreSQL not has any persisten cache for this, and
if you restart connection a backend reload this information again.
Or you can drop/(re)create a function, it is total safe solution.
In response to
pgsql-hackers by date
|Next:||From: Hannu Krosing||Date: 2000-02-10 10:12:04|
|Subject: Re: AW: [HACKERS] Another nasty cache problem|
|Previous:||From: Horák Daniel||Date: 2000-02-10 09:19:28|
|Subject: RE: [HACKERS] Small update for WinNT port|
pgsql-interfaces by date
|Next:||From: Ansley, Michael||Date: 2000-02-10 13:22:09|
|Subject: LO using ODBC/Access|
|Previous:||From: Dave Page||Date: 2000-02-10 09:14:14|
|Subject: RE: [INTERFACES] pgAdmin on NT (NT4SP6)|