On Fri, Feb 21, 2020 at 12:20:33PM +0100, Bruno Thomsen wrote: > Hi Michael > > Den fre. 21. feb. 2020 kl. 08.23 skrev Michael Olbrich > <[email protected]>: > > > > On Sat, Feb 15, 2020 at 01:52:05PM +0100, Bruno Thomsen wrote: > > > Support for foreign_keys pragma was already enabled at > > > compile-time, but it was not enabled by default on new > > > database connections. It's still possible to turn off > > > enforcement at runtime. > > > This makes it easier to work on databases that uses > > > this feature without causing them to end up in an > > > invalid state. > > > > Hmm, what's the impact of this? What are the performance implications? And > > what's the default in other distros? I mean, if the default is generally > > off, then I don't expect any existing software to disable this. > > Fedora 31 has =0, I don't know about other distros, > but you can test it fast with an in-memory database. > > $ sqlite3 > sqlite> pragma foreign_keys; > 1 > sqlite> .exit
FTR: on Debian the pragma command yields 0. (Tested with sqlite3 3.31.1-2 that is currently in testing/unstable) Best regards Uwe -- Pengutronix e.K. | Uwe Kleine-König | Industrial Linux Solutions | https://www.pengutronix.de/ | _______________________________________________ ptxdist mailing list [email protected]
