From: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | delete on cascade |
Date: | 2006-10-23 08:49:16 |
Message-ID: | 200610231049.16507.fluca1978@infinito.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi all,
I guess this is an already asked question, but I didn't found an answer, so
apologize me. Imagine I've got two tables:
skill(id,description) // primary key => id
family(id,description) // primary key => id
and I want to associate skills to families:
ass_sf(id_skill,id_family) // appropriate foreign keys
Tables are already created and the database is running. Now I'd like to
implement a delete cascade, thus when I delete a skill also its association
with the family must be deleted. I gues I should have declared the skill
table as follows:
CREATE TABLE skill
(
id varchar(20) on delete cascade,
description varchar(50),
primary key(id)
);
right? The problem is: how can I alter the table to add the column constraint
now, without redeclaring the table?
Thanks very much for helping me.
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2006-10-23 09:00:20 | Re: delete on cascade |
Previous Message | Michael Fuhr | 2006-10-22 15:45:56 | Re: Crosstab question |