pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRegarding ERROR: fmgr_info: function 2720768: cache lookup failed
2+ messages / 2 participants
[nested] [flat]
* Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
@ 2006-06-22 04:58 soni de <soni.de@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: soni de @ 2006-06-22 04:58 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
@ 2006-06-22 14:47 Tom Lane <tgl@sss.pgh.pa.us>
parent: soni de <soni.de@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2006-06-22 14:47 UTC (permalink / raw)
To: soni de <soni.de@gmail.com>; +Cc: pgsql-performance
"soni de" <soni.de@gmail.com> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-06-22 14:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-22 04:58 Regarding ERROR: fmgr_info: function 2720768: cache lookup failed soni de <soni.de@gmail.com>
2006-06-22 14:47 ` Tom Lane <tgl@sss.pgh.pa.us>
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