Future request: BgBouncer && "cache lookup failed for function": Auto recache function.

"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

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