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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Oleg Serov" <serovov(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Future request: BgBouncer && "cache lookup failed for function": Auto recache function.
Date: 2008-12-14 00:42:46
Message-ID: 14706.1229215366@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Oleg Serov" <serovov(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2008-12-14 00:52:28 Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
Previous Message Tom Lane 2008-12-14 00:38:25 Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3