Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B2AA56326D5 for ; Sat, 13 Feb 2010 07:24:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 48472-07 for ; Sat, 13 Feb 2010 11:23:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f214.google.com (mail-ew0-f214.google.com [209.85.219.214]) by mail.postgresql.org (Postfix) with ESMTP id A6759632D53 for ; Sat, 13 Feb 2010 07:23:55 -0400 (AST) Received: by ewy6 with SMTP id 6so562372ewy.34 for ; Sat, 13 Feb 2010 03:23:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=YT9GUzRX7+N9jkM3up8Qghgiqyf78IF8LcNjP2jVh8c=; b=QhVdPAUnDL6VVo6TA55kjpTfCWZmHdRfUE/RDW5Jpurxs4vZHvRAFER3Ktpt6WIlY6 /9v0zolcpKQ/OJrppeM32xu69rgpJSFpDYyWqRcwZvsiMGkGUfOQyeXHn4AZsGxpFsyp UhaPTQJNUGV0e6KD2wAWe12C64jpEJ6cNLCbQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=tBevndSrxAnwAER+GZAIcqcKCJW6FxKsmOjHBma8RoDZafxoXUje8XuxbaMr7APdfP PubqF/ODBZIXHgcHEnx9hTgePgcBAe9dH4LrHLWiW8PMmibuVyIaPeO73JTPQo92m+rx IAvx0LpEEk4JZjRc/a29zIDridr+pEyT9oozg= MIME-Version: 1.0 Received: by 10.216.86.129 with SMTP id w1mr1564972wee.145.1266060233666; Sat, 13 Feb 2010 03:23:53 -0800 (PST) In-Reply-To: References: <6caee9521002120424l27ec8d3eq3b69522d0a773686@mail.gmail.com> <6caee9521002122211q7e4fd2fcj1a0489fd64dc204a@mail.gmail.com> Date: Sat, 13 Feb 2010 06:23:53 -0500 Message-ID: Subject: Re: Can i force deletion of dependent rows? From: "Wayne E. Seguin" To: pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201002/52 X-Sequence-Number: 33651 Is there another answer, asside from in the application and/or as a trigger using `DELETE FROM B WHERE z = 'x';` as it's body? ~Wayne