X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 873919FA60A for ; Thu, 22 Jun 2006 11:47:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 86772-06 for ; Thu, 22 Jun 2006 11:47:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 6964C9F9ED6 for ; Thu, 22 Jun 2006 11:47:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k5MElRRu029674; Thu, 22 Jun 2006 10:47:27 -0400 (EDT) To: "soni de" cc: pgsql-performance@postgresql.org Subject: Re: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed In-reply-to: <9f2e40a90606212158p58652b2bg4d5f4500b3564641@mail.gmail.com> References: <9f2e40a90606212158p58652b2bg4d5f4500b3564641@mail.gmail.com> Comments: In-reply-to "soni de" message dated "Thu, 22 Jun 2006 10:28:11 +0530" Date: Thu, 22 Jun 2006 10:47:27 -0400 Message-ID: <29673.1150987647@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/446 X-Sequence-Number: 19803 "soni de" writes: > I am getting following error while inserting a row into the "abc" table: > *ERROR: fmgr_info: function 2720768: cache lookup failed* What PG version is this? (I can tell from the spelling of the error message that it's older than 7.4.) If it's pre-7.3 then the answer is probably that you dropped and re-created the function, and now need to drop and re-create the trigger to match. 7.3 shouldn't have let you drop a function that has a trigger depending on it, though. BTW this seems a bit off-topic for pgsql-performance. regards, tom lane