|Subject:||DBIx::Class::Row delete method bug or feature for SQLite database|
Hello! Maybe I am wrong but in my opinion this is a bug. Below is a case description for SQLite database. I have a parent table with has_many relationship to child table. In parent table primary key is ID. In child table there isn't primary key, only foreign key ParentID to parent table. When I try to delete row from parent table I get exception "Cannot safely delete a row in a PK- less table". For mysql everything is OK. If I add primary key to child table the problem will gone for SQLite as well. Maybe there is a restriction somewhere in documentation that I have to create primary key, but I haven't found it.