Re: Bug in foreign keys

2003-01-10 Thread Rafal Jank
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

Re: Bug in foreign keys

2003-01-10 Thread Rafal Jank
- Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 11:04 PM Subject: Re: Bug in foreign keys Rafal, - Original Message - From: Rafal Jank [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday

Re: Bug in foreign keys

2003-01-10 Thread Heikki Tuuri
MySQL-Max from http://www.mysql.com sql query . Subject: Re: Bug in foreign keys From: Rafal Jank Date: Fri, 10 Jan 2003 11:10:35 +0100 On Thu, 09 Jan 2003 23:41:46 +0200 Heikki Tuuri

Re: Bug in foreign keys

2003-01-10 Thread Rafal Jank
for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query . Subject: Re: Bug in foreign keys From: Rafal Jank Date: Fri, 10 Jan 2003 11:10:35 +0100

Bug in foreign keys

2003-01-09 Thread Rafal Jank
Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10) NOT NULL default '0', `lozka_p` char(2) default NULL, `tv_p` char(1) default NULL, `lazienka_p` char(1) default NULL, `cena_p` int(10) default NULL, `zaliczka_p` int(10) default

Re: Bug in foreign keys

2003-01-09 Thread Paul DuBois
At 16:11 +0100 1/9/03, Rafal Jank wrote: Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10) NOT NULL default '0', `lozka_p` char(2) default NULL, `tv_p` char(1) default NULL, `lazienka_p` char(1) default NULL, `cena_p` int(10)

Re: Bug in foreign keys

2003-01-09 Thread Rafal Jank
At 16:11 +0100 1/9/03, Rafal Jank wrote: Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10) NOT NULL default '0', `lozka_p` char(2) default NULL, `tv_p` char(1) default NULL, `lazienka_p` char(1) default NULL,

Re: Bug in foreign keys

2003-01-09 Thread Heikki Tuuri
Rafal, - Original Message - From: Rafal Jank [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, January 09, 2003 6:18 PM Subject: Bug in foreign keys Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10

Re: Bug in foreign keys

2003-01-09 Thread Heikki Tuuri
affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 11:04 PM Subject: Re: Bug in foreign keys Rafal, - Original Message - From: Rafal Jank [EMAIL PROTECTED