Received: from mail3.svr.pol.co.uk (mail3.svr.pol.co.uk [195.92.193.19]) by postgresql.org (Postfix) with ESMTP id C923A475CE5 for ; Tue, 5 Mar 2002 09:42:31 -0500 (EST) Received: from [195.92.168.141] (helo=tmailb1.svr.pol.co.uk) by mail3.svr.pol.co.uk with esmtp (Exim 3.35 #1) id 16iG9D-0005GV-00 for pgsql-sql@postgresql.org; Tue, 05 Mar 2002 14:42:35 +0000 Received: from modem-923.lynx.dialup.pol.co.uk ([217.135.195.155] helo=cs.man.ac.uk) by tmailb1.svr.pol.co.uk with esmtp (Exim 3.35 #1) id 16iG9C-0005Ku-00 for pgsql-sql@postgresql.org; Tue, 05 Mar 2002 14:42:34 +0000 Message-ID: <3C84D9D4.CD533AD3@cs.man.ac.uk> Date: Tue, 05 Mar 2002 14:44:36 +0000 From: Ismail Bouabdallah X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.7-10enterprise i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: ERROR: fmgr_info: function 56664: cache lookup failed Content-Type: multipart/mixed; boundary="------------13BF0E3AFB28292BD66DAB61" X-Archive-Number: 200203/56 X-Sequence-Number: 6938 This is a multi-part message in MIME format. --------------13BF0E3AFB28292BD66DAB61 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------13BF0E3AFB28292BD66DAB61 Content-Type: text/x-vcard; charset=us-ascii; name="bouabdi9.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Ismail Bouabdallah Content-Disposition: attachment; filename="bouabdi9.vcf" begin:vcard n:Bouabdallah;Ismail x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:bouabdi9@cs.man.ac.uk` title:Mr I.Bouabdallah x-mozilla-cpt:;0 fn:Ismail Bouabdallah end:vcard --------------13BF0E3AFB28292BD66DAB61--