Received: from smtp.datacomm.ch (smtp.datacomm.ch [212.40.5.52]) by hub.org (8.9.2/8.9.1) with ESMTP id MAA22099 for ; Sun, 21 Feb 1999 12:39:46 -0500 (EST) (envelope-from wreis@datacomm.ch) Received: from tribe.free.de (line43-zuerich.datacomm.ch [212.254.24.57]) by smtp.datacomm.ch (8.9.0/8.9.0) with ESMTP id SAA26031 for ; Sun, 21 Feb 1999 18:39:41 +0100 Received: from quod.free.de (unknown [192.168.20.50]) by tribe.free.de (Postfix) with ESMTP for id 4068612629; Sun, 21 Feb 1999 18:38:54 +0100 (MET) Received: (from werner@localhost) by quod.free.de (8.8.5/8.7.3) id SAA02337 for pgsql-sql@postgreSQL.org; Sun, 21 Feb 1999 18:38:11 +0100 X-Authentication-Warning: quod.free.de: werner set sender to wreis@datacomm.ch using -f Message-ID: <19990221183810.C273@tribe.free.de> Date: Sun, 21 Feb 1999 18:38:10 +0100 From: Werner Reisberger To: pgsql-sql@postgreSQL.org Subject: triggers (refint) Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93.2i Trying to use the function check_primary_key with the examples provided in postresql 6.3.1 I am getting the error message "fmgr_info: function 157189: cache lookup failed" Apart from this problem I would like to extend the function of check_foreign_key to delete the whole row instead of only the foreign_key. I think it's possible to write a second trigger function which will delete the whole row if the foreign_key field is null. Or do I need to customize the refint source? Werner