Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 242742E0076 for ; Wed, 2 Apr 2008 14:42:41 -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 83709-04 for ; Wed, 2 Apr 2008 14:42:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54306.mail.re2.yahoo.com (web54306.mail.re2.yahoo.com [206.190.49.116]) by developer.postgresql.org (Postfix) with SMTP id AE1FC2E006D for ; Wed, 2 Apr 2008 14:42:37 -0300 (ADT) Received: (qmail 46417 invoked by uid 60001); 2 Apr 2008 17:42:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=N8r4JgY1udzB0HSwWit8q7WJAiAaCmxzkCEJ1fS3iHLIk7d5bnmfazfxOLPtK5myPqa8VF0QnHC/+UYTkI+xlvrIzqpu6Zy3P31dvKjqx3AiwKkFXfBIssnaTBsVI+xsSFfZQyOrYT54mu8/2xRq799k51L7rjrEeaDvwq2hTdI=; X-YMail-OSG: G00myO0VM1nQW6n5IzP2DWy1x.sAXtKvdfljrTA4kwk3jroybrWWvTYvq82MPb07TlYPugq91aLobjdcUQdjaogKrj8KmVIgKq_Gczpcn5QMnEYjcPonvyP79UU0nQ-- Received: from [70.231.70.207] by web54306.mail.re2.yahoo.com via HTTP; Wed, 02 Apr 2008 10:42:36 PDT Date: Wed, 2 Apr 2008 10:42:36 -0700 (PDT) From: chester c young Subject: apparent RI bug To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <598841.46263.qm@web54306.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/9 X-Sequence-Number: 30548 it appears I have a broken RI in my db. call_individual.clh_id references call_household.clh_id \d call_individual ... Foreign-key constraints: "call_individual_clh_id_fkey" FOREIGN KEY (clh_id) REFERENCES call_household(clh_id) ON DELETE CASCADE however: development=# select clh_id from call_individual cli where not exists( select 1 from call_household clh where clh.clh_id=cli.clh_id ); clh_id -------- 14691 should not matter, but call_individual has a pre-delete trigger that simply raises an exception to prevent deletions: raise exception 'calls may not be deleted'; ____________________________________________________________________________________ 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