| 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: | Whole Thread | Raw Message | 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 |