Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-17 Thread Heikki Tuuri
Paul, - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:05 AM Subject: Re: Foreign Key and default action/RESTRICT behaviour? At 23:12 +0200 3/16/03, Heikki Tuuri wrote: Tor, - Original

Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Tor R. Skoglund (NextG)
Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION | RESTRICT}] [ON UPDATE

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Paul DuBois
At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote: Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Heikki Tuuri
Tor, - Original Message - From: Tor R. Skoglund (NextG) [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Paul DuBois
At 23:12 +0200 3/16/03, Heikki Tuuri wrote: Tor, - Original Message - From: Tor R. Skoglund (NextG) [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? Hi List, regarding the foreign key

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Paul DuBois
At 14:29 -0600 3/16/03, Paul DuBois wrote: At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote: Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Andreas
RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. Paul DuBois wrote: I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the impression that RESTRICT wasn't even

Re: Foreign Key and default action/RESTRICT behaviour?

2003-03-16 Thread Paul DuBois
At 4:13 +0100 3/17/03, Andreas wrote: RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. Paul DuBois wrote: I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the