Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 803962E0049 for ; Thu, 3 Apr 2008 15:13:26 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 71240-04-6 for ; Thu, 3 Apr 2008 15:13:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54301.mail.re2.yahoo.com (web54301.mail.re2.yahoo.com [206.190.49.111]) by developer.postgresql.org (Postfix) with SMTP id 420FB2E0074 for ; Thu, 3 Apr 2008 15:13:17 -0300 (ADT) Received: (qmail 33291 invoked by uid 60001); 3 Apr 2008 18:13:13 -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=185dIXxKuz/GfTl+0v+esYMw2owFcvbSg63UOaUK2ZRwcuz6xQCxZ+fv6uv3SE4PzL4tIUj675dxuMruyzT+Rx6jQkbIPvMMJ3kXvpJh5uhBGNqmGir3ouAjn1x7jT3wxVIW9WrEsTtzYRpfLr9zBDfim8ZaW2IP/Bdx43dMr/c=; X-YMail-OSG: 2Wx99OoVM1muT.8oejPVUlyrNGjv6IbGRQ8CgK6W Received: from [70.231.70.207] by web54301.mail.re2.yahoo.com via HTTP; Thu, 03 Apr 2008 11:13:13 PDT Date: Thu, 3 Apr 2008 11:13:13 -0700 (PDT) From: chester c young Subject: Re: apparent RI bug To: Stephan Szabo Cc: sql pgsql In-Reply-To: <20080403102340.B14656@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <702370.31991.qm@web54301.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/24 X-Sequence-Number: 30563 Stephan Szabo wrote: > On Wed, 2 Apr 2008, chester c young wrote: > > > it appears I have a broken RI in my db. > Yeah, that looks pretty broken. Can you reproduce this from a clean > start repeatedly or is this a one off? Do you ever turn off triggers, > perhaps by modifying the pg_class row's reltriggers (I'd guess the > answer is no, but it'd be good to make sure)? only one error. unable to duplicate so far. this is a development db - triggers are frequently dropped and created, but I don't think ever concurrently with db activity. ____________________________________________________________________________________ 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