| 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.