On Thu, 09 Jan 2003 23:04:37 +0100 "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> wrote:
> Rafal, > > > alter table rezerwacje add foreign key (nip_h,nrpok_p) references > > pokoje(nip_h,nrpok_p); > > > ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150) > > Most probably, you are using MySQL >= 4.0.1 but < 4.0.5. I had these > kind of problems with ALTER TABLE with 4.0.1 and 4.0.4, but not with > 4.0.7 anymore (hey, this rhymes :). I guess it has nothing to do with > the foreign keys, but with the temporary form table MySQL creates when > you do an ALTER TABLE. Anyway, the problem seems to be fixed, so you > should update to >= 4.0.7. > Well, I'm using 4.0.8 -- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php