Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 8225F4759D4 for ; Thu, 1 Aug 2002 10:01:44 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g71E19Vk007022; Thu, 1 Aug 2002 10:01:10 -0400 (EDT) To: Archibald Zimonyi Cc: pgsql-sql Subject: Re: Function problems, cache lookup failed In-reply-to: References: Comments: In-reply-to Archibald Zimonyi message dated "Thu, 01 Aug 2002 11:47:35 +0200" Date: Thu, 01 Aug 2002 10:01:09 -0400 Message-ID: <7021.1028210469@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200208/9 X-Sequence-Number: 8855 Archibald Zimonyi writes: > ERROR: fmgr_info: function 18308: cache lookup failed > I have no idea what this is, can anyone help me? The aggregate links to the function by OID. You deleted the function and recreated it, which means it's a new function with a new OID and so the aggregate is broken. You'll need to drop and recreate the aggregate too. Next time use CREATE OR REPLACE FUNCTION so you don't need to do that. (With CREATE OR REPLACE, you are just modifying the existing function, so its OID doesn't change.) 7.3 will prevent this sort of mistake... regards, tom lane