Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 804429FB293
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 23 Oct 2006 06:51:15 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 63011-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 23 Oct 2006 06:50:22 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from aa014msg.fastweb.it (aa014msg.fastweb.it [213.140.2.81])
	by postgresql.org (Postfix) with ESMTP id B65D09FA491
	for <pgsql-sql@postgresql.org>; Mon, 23 Oct 2006 06:50:21 -0300 (ADT)
Received: from ms006msg.fastweb.it (10.31.41.46) by aa014msg.fastweb.it
	(7.3.105.6) id 4535D64B0026FE38 for pgsql-sql@postgresql.org;
	Mon, 23 Oct 2006 11:50:19 +0200
Received: from [192.168.1.201] (85.18.239.131) by ms006msg.fastweb.it
 (7.2.070)
	id 44AD188302B34AF7 for pgsql-sql@postgresql.org;
	Mon, 23 Oct 2006 11:50:19 +0200
From: Luca Ferrari <fluca1978@infinito.it>
To: pgsql-sql@postgresql.org
Subject: Re: delete on cascade
Date: Mon, 23 Oct 2006 11:50:18 +0200
User-Agent: KMail/1.9.5
References: <200610231049.16507.fluca1978@infinito.it>
	<200610231200.20932.achill@matrix.gatewaynet.com>
In-Reply-To: <200610231200.20932.achill@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-7"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200610231150.18115.fluca1978@infinito.it>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.908 tagged_above=0 required=5 tests=AWL,
	SPF_HELO_SOFTFAIL, SPF_SOFTFAIL
X-Spam-Level: *
X-Archive-Number: 200610/201
X-Sequence-Number: 26590

On Monday 23 October 2006 11:00 Achilleas Mantzios's cat, walking on the 
keyboard, wrote:
> not right!!!
> ON DELETE CASCADE is specified in FOREIGN KEY contsraints.
> So that would be in ass_sf table.
> If you find ALTER TABLE ass_sf command hard to run, then drob your
> ass_sf table and define it like
>


Sorry, but this would define that when I delete a row on ass_sf also the skin 
and the family will be deleted, right? I would like to get the opposite 
behaviour: when I delete a skill also its association on ass_sf will be 
deleted. Is this possible?

Thanks,
Luca