[skdb] `read-only` `INSERT` forbidden?
Closed this issue · 2 comments
ltique commented
I was a bit surprised that I can't insert a row with skdb_access
set to read-only
:
INSERT INTO messages (username, message, skdb_access) VALUES ('user2', 'msg3', 'read-only');
Could not eval query. Try `.help`
SkRuntimeExit [Error]: INSERT INTO messages (username, message, skdb_access) VALUES ('user2', 'msg3', 'read-only');
^
|
----- ERROR
Error: line 1, character 0:
cannot insert with skdb_access set to read-only (user f8b7WiJln5Scgj-T5inTJcn7Fi)
...
What are the valid values of skdb_access
? Are they: user ID; group ID; read-write
; and that's it? Or are there are other valid predefined groups one can use?
gregsexton commented
read-only is only really useful for server-side virtual views.
beauby commented
Closing skdb-specific issues as skdb in its current form is being deprecated.