[odb-users] sqlite ON UPDATE CASCADE

Boris Kolpackov boris at codesynthesis.com
Wed Oct 24 08:42:36 EDT 2018

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.

More information about the odb-users mailing list