On 03/04/2016 11:03 PM, Dominique Devienne wrote: > On Fri, Mar 4, 2016 at 4:48 PM, Richard Hipp <drh at sqlite.org> wrote: > >> https://www.sqlite.org/draft/releaselog/3_12_0.html > > - from 2000 to -2000 > + from 2000 to 500 > > [OT] The PRAGMA defer_foreign_keys=ON statement now also disables RESTRICT > actions on foreign key. > > I've confused by that Richard. Does that mean handling of the RESTRICT is > also postponed to commit-time, > or that RESTRICT is not honored in deferred FK mode (and thus violating > referential integrity). --DD Technically SQLite does the latter, but I don't think that opens up any new opportunities to violate referential integrity.
But as far as I can tell "the RESTRICT is also postponed to commit-time" and "RESTRICT is not honored" are indistinguishable from the users point of view. See the notes on RESTRICT here: http://sqlite.org/foreignkeys.html#fk_actions Dan.
