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
Message-ID: <200610231150.18115.fluca1978@infinito.it> (raw)
In-Reply-To: <200610231200.20932.achill@matrix.gatewaynet.com>
References: <200610231049.16507.fluca1978@infinito.it>
<200610231200.20932.achill@matrix.gatewaynet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fluca1978@infinito.it
Subject: Re: delete on cascade
In-Reply-To: <200610231150.18115.fluca1978@infinito.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox