Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6E6342E0049 for ; Thu, 3 Apr 2008 17:16:49 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43592-02 for ; Thu, 3 Apr 2008 17:16:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54305.mail.re2.yahoo.com (web54305.mail.re2.yahoo.com [206.190.49.115]) by developer.postgresql.org (Postfix) with SMTP id 722062E002D for ; Thu, 3 Apr 2008 17:16:44 -0300 (ADT) Received: (qmail 21431 invoked by uid 60001); 3 Apr 2008 20:16:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=rZFONXcHXpmlGJT0OkSqsg+JsLnOh5wITWZxn9zb7/a7VVweB54LquWFZ/vy73lPOWXPivrjzKDQROKufXdvSTY8UHR/bpZPMvJLzYJ0SFxAMknA7oCjrTXKoubLx85ls9wvXAX+xKj3nCG92TpUug5waY2DVDVI/8IOIAafeiw=; X-YMail-OSG: fsADLTkVM1kz8MfFoGb5dxCH1iBjK9craJpK2L8vjYU.I0UR0NhUgRPsSWiw3brI3w-- Received: from [70.231.70.207] by web54305.mail.re2.yahoo.com via HTTP; Thu, 03 Apr 2008 13:16:42 PDT Date: Thu, 3 Apr 2008 13:16:42 -0700 (PDT) From: chester c young Subject: Re: apparent RI bug To: Stephan Szabo Cc: sql pgsql In-Reply-To: <20080403113003.Q17782@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <811324.18014.qm@web54305.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/27 X-Sequence-Number: 30566 --- Stephan Szabo wrote: > Is it possible you ever had a before delete trigger that just did a > return > NULL rather than raising an exception? IIRC, explicitly telling the > system to ignore the delete will work on the referential actions. yes, it is possible, for example, a function without a body or without a "return old". are you saying this would override the RI constraint? if so, is this by design? ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com