Thread: Future request: BgBouncer && "cache lookup failed for function": Auto recache function.
Future request: BgBouncer && "cache lookup failed for function": Auto recache function.
From
"Oleg Serov"
Date:
Hello!. I'm using PgBouncer with permanent connection, So, when i deleting(or editing?) some functions i have an error ERROR: cache lookup failed for function ......; Can you make recaching of invalidate functions?
Re: Future request: BgBouncer && "cache lookup failed for function": Auto recache function.
From
Tom Lane
Date:
"Oleg Serov" <serovov@gmail.com> writes:
> Hello!. I'm using PgBouncer with permanent connection, So, when i
> deleting(or editing?) some functions i have an error
> ERROR: cache lookup failed for function ......;
You're going to need to explain exactly what you're doing if you
want help with that. However, if the answer is that you're doing
DROP/CREATE of existing functions, then the fix is to use CREATE OR
REPLACE FUNCTION instead.
regards, tom lane
Re: Future request: BgBouncer && "cache lookup failed for function": Auto recache function.
From
"Joshua D. Drake"
Date:
On Sun, 2008-12-14 at 03:28 +0300, Oleg Serov wrote: > Hello!. I'm using PgBouncer with permanent connection, So, when i > deleting(or editing?) some functions i have an error > ERROR: cache lookup failed for function ......; > Can you make recaching of invalidate functions?' I believe it already does that if you are running 8.3. Joshua D. Drake > -- PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company,serving since 1997