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 8D1599FA430 for ; Thu, 22 Jun 2006 01:58:26 -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 11412-07 for ; Thu, 22 Jun 2006 01:58:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 4AEF79F9ED6 for ; Thu, 22 Jun 2006 01:58:13 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id f28so194941pyf for ; Wed, 21 Jun 2006 21:58:11 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=BbjwjCifeWU6PGuTE2+SC9dY0+39mrwMS6Gfv+EsAPyvQsZJTWEFWajU/tH73KFC9q6itCQ09ysx6zvCKcDMiyH2qGxOlkS2HVhivqjcYOk4DsjkdzufxCdguQpJP+srhRn31eUbcLzVgWDIdiCc/V8B92LxHUeohGx9fulOkQU= Received: by 10.35.101.9 with SMTP id d9mr643117pym; Wed, 21 Jun 2006 21:58:11 -0700 (PDT) Received: by 10.35.8.14 with HTTP; Wed, 21 Jun 2006 21:58:11 -0700 (PDT) Message-ID: <9f2e40a90606212158p58652b2bg4d5f4500b3564641@mail.gmail.com> Date: Thu, 22 Jun 2006 10:28:11 +0530 From: "soni de" To: pgsql-performance@postgresql.org Subject: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2642_19247636.1150952291370" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/430 X-Sequence-Number: 19787 ------=_Part_2642_19247636.1150952291370 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello, I am getting following error while inserting a row into the "abc" table: *ERROR: fmgr_info: function 2720768: cache lookup failed* * * Table "abc" has one trigger called "abct" Definition is as follows: BEGIN; LOCK TABLE abc IN SHARE ROW EXCLUSIVE MODE; create TRIGGER abct AFTER INSERT OR DELETE on abc FOR EACH ROW EXECUTE PROCEDURE abc_function(); COMMIT; abc_function() updates entry from the "xyz" table for every insert and delete operations on table "abc". "xyz" table maintains the count of total number of rows in table "abc" Currently "abc" table contains 1000090 rows. And same count is available in table "xyz". But now I am not able to insert any records into the "abc" table because of above mentioned error. Please provide me some help regarding this. Thanks, Soni ------=_Part_2642_19247636.1150952291370 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

Hello,

 

I am getting following error while inserting a row into the "abc" table:

ERROR:  fmgr_info: function 2720768: cache lookup failed

 

Table "abc" has one trigger called "abct"

Definition is as follows:

 

BEGIN;

   LOCK TABLE abc IN SHARE ROW EXCLUSIVE MODE;

 

   create TRIGGER abct

      AFTER INSERT OR DELETE on abc

      FOR EACH ROW EXECUTE PROCEDURE abc_function();

 

COMMIT;

 

abc_function() updates entry from the "xyz" table for every insert and delete operations on table "abc".

 

"xyz" table maintains the count of total number of rows in table "abc"

 

Currently "abc" table contains 1000090 rows. And same count is available in table "xyz".

But now I am not able to insert any records into the "abc" table because of above mentioned error.

 

Please provide me some help regarding this.

 

Thanks,

Soni

------=_Part_2642_19247636.1150952291370--