Re: delete on cascade - Mailing list pgsql-sql

From Luca Ferrari
Subject Re: delete on cascade
Date
Msg-id 200610231150.18115.fluca1978@infinito.it
Whole thread Raw
In response to Re: delete on cascade  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: delete on cascade  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: delete on cascade
Next
From: Achilleas Mantzios
Date:
Subject: Re: delete on cascade