List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:February 28 2005 3:45pm
Subject:Re: alter table return error
View as plain text  
Did you try perror?

   ~: perror 150
   Error code 150:  Unknown error: 150
   150 = Foreign key constraint is incorrectly formed


Philippe Poelvoorde wrote:

> Hi,
> I'm trying to add an 'unsigned' attribute to one column :
>  > alter table markets modify Id integer unsigned not null auto_increment;
> ERROR 1025: Error on rename of './eurex_dax/#sql-1d2c_2f' to 
> './eurex_dax/markets' (errno: 150)
> The query runs without any problems on any others tables (all are 
> innoDB), all permissions seems to be fine. I don't really know where to 
> look for hints, any ideas ?
alter table return errorPhilippe Poelvoorde28 Feb
  • Re: alter table return errorMichael Stassen28 Feb
    • Re: alter table return errorPhilippe Poelvoorde28 Feb