Alter table primary key and foreign keys

2004-05-18 Thread Rich Schramm
I am using mysql 4.0.12 max-nt on Windows XP. I have a master table with an int column as a primary key (bom_id) and a second table that has a foreign key reference to the master column and uses it as part of a composite key (bom_id, fc_date). Example: ** bom_mstr

RE: Alter table primary key and foreign keys

2004-05-18 Thread Rich Schramm
The error log shows nothing when the binary dies. I can't rebuild the child table - anything that touches the child table after the alter stops the binary. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 2:07 PM To: 'Rich Schramm

RE: Arithmetic Bug in 4.0.12/13-max

2003-06-18 Thread Rich Schramm
this. Any help would be much appreciated! Thanks, Rich -Original Message- From: Alexander Keremidarski [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 5:51 PM To: Rich Schramm Cc: [EMAIL PROTECTED] Subject: Re: Arithmetic Bug in 4.0.12/13-max Hello, Rich Schramm wrote: I have

RE: Arithmetic Bug in 4.0.12/13-max

2003-06-18 Thread Rich Schramm
. Rich -Original Message- From: Rich Schramm [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 9:07 AM To: 'Alexander Keremidarski'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Arithmetic Bug in 4.0.12/13-max OK, I have been working on this for the last day. I read the manual