PRAGMA foreign_keys are turning them off even we turn them on. about rqlite HOT 4 CLOSED

Sample of what's going on

127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 0            |
+--------------+
127.0.0.1:4001> PRAGMA foreign_keys=on;
127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 1            |
+--------------+
127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 1            |
+--------------+
127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 0            |
+--------------+
127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 0            |
+--------------+
127.0.0.1:4001> PRAGMA foreign_keys=on;
127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 1            |
+--------------+
127.0.0.1:4001> PRAGMA foreign_keys;
+--------------+
| foreign_keys |
+--------------+
| 0            |
+--------------+
127.0.0.1:4001> 

from rqlite.

I know why this is happening, and will make it clearer in the docs.

However, the best way to enable Foreign Keys in rqlite is via a flag at launch time, like so:

rqlited -fk node1

Try that for now, and let me know how it goes.

from rqlite.

I know why this is happening, and will make it clearer in the docs.

However, the best way to enable Foreign Keys in rqlite is via a flag at launch time, like so:

rqlited -fk node1

Try that for now, and let me know how it goes.

A-ha.. I was about to reference this 3 year old discussion, but thanks for the answer.. https://sqlite.org/forum/info/c5dc50f61b88c587

Good to know its supported. I am testing right now..

from rqlite.

Try that for now, and let me know how it goes.

Yes. -fk makes foreign_keys on all the time. thanks. By the way may i suggest to add one single inital page in the docs (may be to be enhanced by the community) on the current options that rsyncd has "bunch of options" at command line.. would help to google search the issue.. I've just noticed them now :)

from rqlite.