[odb-users] sqlite ON UPDATE CASCADE

[Boris Kolpackov]

MM <finjulhich at gmail.com> writes:

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