Posted by Rik on 01/24/07 16:46

On Wed, 24 Jan 2007 17:28:19 +0100, Erwin Moller
> I only gave samplecode: In my real database I kept receiving an annoying
> errno: 105.
> On mysql website this is listed as 'internal InnoDB error regarding a
> FOREIGN KEY'.
>
> After some investigation I found the reason was this:
> - On the parenttable I used 'unsigned' for the auto_increment PK column.
> - When referencing it I ommitted that 'unsigned'.
>
> I would like to use this oppertunity to thank the mySQL team for their
> great, clear, and lengthy errordescriptions.

Error descriptions for foreign key errors (if at all described) are awful
indeed.

> OMG, do I miss PostgreSQL!
> (For dutchies: Why does XS4ALL not offer that?)

LAMP is somewhat standard, most people would want MySQL, and to cut costs,
stingy as the dutch are, they refuse to put any effort in an alternative.
--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *

[Back to original message]