Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAUKQhF04284 for ; Thu, 30 Nov 2000 15:26:47 -0500 (EST) (envelope-from brian@owlscreech.com) Received: from sisyphus.owlscreech.com (IDENT:root@owlscreech.com [207.174.31.35]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id QAA95387 for ; Thu, 30 Nov 2000 16:01:37 GMT (envelope-from brian@owlscreech.com) Received: from [192.168.0.2] ([63.229.251.51]) by sisyphus.owlscreech.com (8.9.3/8.8.7) with ESMTP id MAA31051 for ; Thu, 30 Nov 2000 12:47:36 -0700 User-Agent: Microsoft-Entourage/9.0.2509 Date: Thu, 30 Nov 2000 12:47:43 -0700 Subject: I get an error with Foreign Keys From: Brian Powell To: Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200011/292 X-Sequence-Number: 323 I have around 40 tables defined, many relying on data in others so I have foreign key constraints. However, whenever I try to delete from any table, I get: ERROR: SPI_execp() failed in RI_FKey_cascade_del() What generates this? I need assistance in knowing where to begin. I checked again, and I could not find any circular foreign key constraints... Any help on where to search is appreciated. Thanks, --Brian