ERROR: fmgr_info: function 56664: cache lookup failed

From: Ismail Bouabdallah <bouabdi9(at)cs(dot)man(dot)ac(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: ERROR: fmgr_info: function 56664: cache lookup failed
Date: 2002-03-05 14:44:36
Message-ID: 3C84D9D4.CD533AD3@cs.man.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

can anyone help me with the follwoing:

CREATE FUNCTION new_site() RETURNS OPAQUE AS '
BEGIN
IF NEW.SITE_REFERNCE = SITE_REFERENCE
THEN
SITE.END_DATE := NEW.START_DATE
SITE.CURRENCY_FLAG := 2
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER NEWSITE
AFTER INSERT ON SITE
FOR EACH ROW
EXECUTE PROCEDURE new_site();

This is a trigger that I created to enforce versioning of land_use_sites

in a database I have written.

psql accepts bothe the procedure and the trigger, but after delcaring it

on my database I can no longer insert new land_use_sites into my
database.

psql returns the following error:

ERROR: fmgr_info: function 56664: cache lookup failed

when I try to insert new land_use_sites, such as:

INSERT INTO SITE
(SITE_REFERENCE,UPRN,LA_REFERENCE,VERSION_NO,CURRENCY_FLAG,START_DATE,END_DATE,EASTING,NORTHING,PAO_DESCRIPTION,STREET_DESCRIPTION,LOCALITY_DESCRIPTION,TOWN_DESCRIPTION,POSTCODE,LA_CODE,AREA,LAND_TYPE_REF,LAND_USE_DIVISION_REF,LAND_USE_CLASS_REF,LAND_USE_SUB_CLASS_REF,DERELICTION_REF,OWNER_REF,PLANNING_STATUS_REF,PROPOSED_USE_REF,HOUSING_COMPONENT,HOUSING_SUIT_REF,MOST_SUITABLE_USE_REF,EST_HOUSING_CAPACITY,HOUSING_DENSITY,LEGAL_CONSTRAINTS,PHYSICAL_CONSTRAINTS,AVAILABLE_ON_MARKET,AGENT_NAME,EP_RDA_INVOLVEMENT,GENERAL_SITE_INFORMATION,BOUNDARY_ID)

VALUES (345600001,null,null,2,1,'20020311',null,414722,130160,'57 TO
61','GREENCROFT STREET',null,'SNAILSBURY','SN3
5BX',3456,0.062,2,11,44,133,11,3,4,2,4,1,2,10,161,1,2,3,null,2,null,3456000011);

Is the syntax of the procedure correct?
Does anybody have any suggestions?

Best Regards
Ismail

Attachment Content-Type Size
bouabdi9.vcf text/x-vcard 188 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Ashley Clark 2002-03-05 15:49:28 Re: PL/pgSQL Syntax Problem
Previous Message Ismail Bouabdallah 2002-03-05 14:32:37 function error: ERROR:   fmgr_info: function 56664: cache lookup failed