Re: [INTERFACES] The persistance of C functions

From: Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz>
To: Bryan White <bryan(at)arcamax(dot)com>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] The persistance of C functions
Date: 2000-02-10 09:42:29
Message-ID: Pine.LNX.3.96.1000210103409.21359B-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces


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.

Karel

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2000-02-10 10:12:04 Re: AW: [HACKERS] Another nasty cache problem
Previous Message Horák Daniel 2000-02-10 09:19:28 RE: [HACKERS] Small update for WinNT port

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ansley, Michael 2000-02-10 13:22:09 LO using ODBC/Access
Previous Message Dave Page 2000-02-10 09:14:14 RE: [INTERFACES] pgAdmin on NT (NT4SP6)