Your "integer primary key" is probably not spelled correctly. You must spell it exactly as "integer primary key". The other possibility is that you are inserting rows and specifying the rowid. It is only automatically generated if it is NULL. Please show the table definition of a table that is misbehaving.