[odb-users] sqlite ON UPDATE CASCADE

[MM]

Hello,

The sql generated by odb say for a member that is std::vector<T> includes a
foreign constraint "ON DELETE CASCADE" so that is the containing object is
deleted from the master table, the relevant rows are deleted from the slave
table.

Is there a pragma to generate "ON UPDATE CASCADE" as well?

Thank you

[Boris Kolpackov]

Post by MM
The sql generated by odb say for a member that is std::vector<T> includes a
foreign constraint "ON DELETE CASCADE" so that is the containing object is
deleted from the master table, the relevant rows are deleted from the slave
table.
Is there a pragma to generate "ON UPDATE CASCADE" as well?

No. This is normally unnecessary since the foreign key points to the
primary key (object id) which cannot be modified.