Re: [SQL] ON DELETE CASCADE question

2002-06-14 Thread Jan Wieck
Josh Berkus wrote: > > Wei, > > > Does ON DELETE CASCADE attribute you specify in CREATE TABLE > > statement > > actually create triggers for every foreign key it refers to? > > > > Yes. Two triggers for each key, I think. Three, one for INSERT OR UPDATE on the FK table, one for UPDAT

Re: [SQL] ON DELETE CASCADE question

2002-06-14 Thread Josh Berkus
Wei, > Does ON DELETE CASCADE attribute you specify in CREATE TABLE > statement > actually create triggers for every foreign key it refers to? > Yes. Two triggers for each key, I think. -Josh ---(end of broadcast)--- TIP 4: Don't 'kill -9' the p