From: | Michael Fraley <fraley(at)usfca(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | Michael Fraley <fraley(at)beta(dot)usfca(dot)edu> |
Subject: | ERROR: fmgr_info: function 19104: cache lookup failed |
Date: | 2000-06-26 22:40:55 |
Message-ID: | 00062422294101.00500@cumquat |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
Hello,
I just upgraded from 6.5.2 to 7.0.2 on SuSE 6.4 Linux, and now I get this
message when trying to insert records:
ERROR: fmgr_info: function 19104: cache lookup failed
This only happens on tables that use refint.so (under contrib/spi in the source
distribution). There is a trigger that calls a function, to check primary or
foreign key. Has anyone else encountered this?
Here's the schema:
create subscriptions table
-------------------
CREATE SEQUENCE "subscriptions_script_id_seq" start 1 increment 1 maxvalue
2147483647 minvalue 1 cache 1 ;
CREATE TABLE "subscriptions" (
"script_id" int4 DEFAULT nextval('subscriptions_script_id_seq') NOT NULL,
"mag_id" int4 NOT NULL,
"paid_amount" money NOT NULL,
"start_date" date NOT NULL,
"end_date" date NOT NULL,
"notes" text);
CREATE UNIQUE INDEX "subscriptions_script_id_key" on "subscriptions" using btree
( "script_id" "int4_ops" );
CREATE TRIGGER "sub_mag_trigger" BEFORE INSERT OR UPDATE ON "subscriptions"
FOR EACH ROW EXECUTE PROCEDURE
check_primary_key ('mag_id', 'magazines', 'mag_id');
create function
------------
CREATE FUNCTION "check_primary_key" ( ) RETURNS opaque AS
'/usr/local/pgsql/lib/modules/refint.so' LANGUAGE 'C';
--
Michael Fraley
fraley(at)usfca(dot)edu
http://www.usfca.edu/~fraley
From | Date | Subject | |
---|---|---|---|
Next Message | Irfan Qaiser | 2000-06-27 07:26:57 | |
Previous Message | Dmitry Morozovsky | 2000-06-26 16:16:09 | Re: Administration tips |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-26 22:41:33 | Re: DateTime fields |
Previous Message | Len Morgan | 2000-06-26 22:22:08 | Re: Conversion from MS Access to Postgresql |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-26 22:48:22 | Re: Big 7.1 open items |
Previous Message | Tom Lane | 2000-06-26 22:33:56 | Re: 'natural join' core dump |