Your subject line is misleading; there is nothing in the body of your post suggesting that you are getting some kind of row lock, nor is there any query.
Have you looked in the MySQL manual? If you have a look at this URL - http://dev.mysql.com/doc/mysql/en/innodb-error-codes.html - you'll see that InnoDB error 1005 means that your table could not be created; the 150 means that your foreign key constraint was not correctly formed. If you look up the REFERENCES clause in the article about the CREATE TABLE statement in the same manual (http://dev.mysql.com/doc/mysql/en/create-table.html), I think you'll see what's wrong with your statement. If you fix that, I think your table will be created correctly. Rhino ----- Original Message ----- From: "Philipp Snizek" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Tuesday, February 22, 2005 11:08 AM Subject: RE: InnoDB Row Lock test (A query maybe?) Hi I must be blind. Please help a DB-Newbie. What's wrong here: create table users ( email varchar (80) unique not null, ownerdomain int not null, foreign key (ownerdomain) references domains on delete cascade ) type=innodb; MySQL sais: ERROR 1005: Can't create table './postfix/users.frm' (errno: 150) Where can I lookup up error codes? Thanks Philipp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.3.0 - Release Date: 21/02/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
