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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2000-02-10 10:12:04
Subject: Re: AW: [HACKERS] Another nasty cache problem
Previous:From: HorĂ¡k DanielDate: 2000-02-10 09:19:28
Subject: RE: [HACKERS] Small update for WinNT port

pgsql-interfaces by date

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

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