Στις Δευτέρα 23 Οκτώβριος 2006 12:50, ο/η Luca Ferrari έγραψε: > 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?
Not right. This would specify quite the opposite. > 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? Absolutely, and this is done in the way i just described. In any case I would recommend reading the docs. > > Thanks, > Luca > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Achilleas Mantzios ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
