Received: from cdselection.wdi.co.uk (root@[195.13.87.250]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA40136 for ; Thu, 24 Feb 2000 12:07:29 -0500 (EST) (envelope-from graham@digitalplanit.com) Received: from Graham (access2-23.gw.cerbernet.net [195.13.123.151]) by cdselection.wdi.co.uk (8.9.3/8.9.3) with SMTP id RAA11949 for ; Thu, 24 Feb 2000 17:17:12 GMT From: "Graham Vickrage" To: Subject: cache lookup failed Date: Thu, 24 Feb 2000 17:08:50 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 I am relatively new to postgres, and am struggling with the following, I am trying to set up a trigger on a table that deletes the foreign key references in the child table, I'm executing the delete command in the usual way (assuming already connected)- delete from website where website_id = '$website_id'; which works fine when there is no trigger on the table but once the trigger is created I get the following error - fmgr_info: function 47172: cache lookup failed Has anyone seen a similar problem, any help would be greatly appreciated. Cheers Graham