From: soni de <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
Date: Thu, 22 Jun 2006 10:28:11 +0530
Message-ID: <9f2e40a90606212158p58652b2bg4d5f4500b3564641@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: soni.de@gmail.com
Subject: Re: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
In-Reply-To: <9f2e40a90606212158p58652b2bg4d5f4500b3564641@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox