Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8RGX5h61402 for ; Thu, 27 Sep 2001 12:33:05 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f8RGWrK28859; Thu, 27 Sep 2001 12:32:53 -0400 (EDT) To: domingo@dad-it.com (Domingo Alvarez Duarte) cc: pgsql-sql@postgresql.org Subject: Re: A bug in triggers PG 7.1.3 or misunderstand ? In-reply-to: <70a76315.0109250034.4b1603c7@posting.google.com> References: <70a76315.0109250034.4b1603c7@posting.google.com> Comments: In-reply-to domingo@dad-it.com (Domingo Alvarez Duarte) message dated "25 Sep 2001 01:34:03 -0700" Date: Thu, 27 Sep 2001 12:32:53 -0400 Message-ID: <28856.1001608373@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200109/262 X-Sequence-Number: 4944 I think you need "return old", not "return new", in the body of the trigger if you want the delete to take place. new would be NULL in a delete situation ... regards, tom lane