Re: Foreign Key Restriction

2005-05-06 Thread Oliver Hirschi
Partha Dutta [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] You can turn off foreign key restrictions within your session: SET SESSION foreign_key_checks = 0; Then later, turn them back on using SET SESSION foreign_key_checks = 1; I saw, that the tables on my

Re: Foreign Key Restriction

2005-05-06 Thread Michael Stassen
Oliver Hirschi wrote: Partha Dutta [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] You can turn off foreign key restrictions within your session: SET SESSION foreign_key_checks = 0; Then later, turn them back on using SET SESSION foreign_key_checks = 1; I saw, that the tables on

Re: Foreign Key Restriction

2005-05-04 Thread Oliver Hirschi
Oliver Hirschi [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hi I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key retrictions. Is it right, that mySQL 4.1.x has something changed due to the foreign key restriction? Is there an option to turn off

RE: Foreign Key Restriction

2005-05-04 Thread Partha Dutta
/certification -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Oliver Hirschi Sent: Wednesday, May 04, 2005 10:50 AM To: mysql@lists.mysql.com Subject: Re: Foreign Key Restriction Oliver Hirschi [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hi I

Foreign Key Restriction

2005-05-03 Thread Oliver Hirschi
Hi I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key retrictions. Is it right, that mySQL 4.1.x has something changed due to the foreign key restriction? Is there an option to turn off the foreign key restriction in mySQL 4.1.1? Thanks. -- Oliver Hirschi http