Repository navigation
PRAGMA foreign_keys = ON; failed #980
Description
Details for the issue
PRAGMA foreign_keys = ON;
Query executed successfully: PRAGMA foreign_keys = ON; (took 0ms)
Run PRAGMA foreign_keys; again and still show 0
I'm opening this issue because:
- DB4S is crashing
- DB4S has a bug
- DB4S needs a feature
- DB4S has another problem
I'm using DB4S on:
- Windows: ( version: ___ )
- Linux: ( distro: ___ )
- Mac OS: ( version: ___ )
- Other: ___
I'm using DB4S version:
- 3.9.1
- 3.9.0
- Other: ___
I have also:
- Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows
- Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
Activity
justinclift commentedon Mar 13, 2017
Interesting. Does it still happen with our recent nightly builds? Download locations are listed on our front page, if that helps. 😄
MKleusberg commentedon May 1, 2017
That happens because we have to execute all SQL commands inside a transaction and the foreign key pragma can't be set inside a transaction. The only reasonable workaround for us that I can think of right now is to somehow detect a
pragma foreign_keys=xstatement and disable transactions for that. But that's always going to be error-prone...@qiulang Do you need to be able to do this using SQL? Or can you just use the GUI editor in the Edit Pragma tab instead?
MKleusberg commentedon May 1, 2017
This also seems to be related to #966.
Allow setting PRAGMAs from the Execute SQL tab
MKleusberg commentedon Jun 30, 2017
@qiulang I believe this is fixed in the next nightly build. Can you download that (see our main page for the link) and check if it's working for you as expected? 😄
justinclift commentedon Nov 9, 2017
Closing this due to lack of response.