On 3-3-2019 16:27, Jesse Rittner wrote:
It didn't work correctly because the sequence of commands you sent doesn't
make sense.
BEGIN;
...
RELEASE point1;
...
ROLLBACK;
...
END;
First you began an explicit transaction. Then you tried to release a
savepoint that you never created. (Hence the "no such savepoint" error
message.) Then you rolled back the explicit transaction. Then you tried to
end (i.e., commit) the explicit transaction, but you already rolled back, so
this is invalid. (Hence the "no transaction is active" error message.)
I'm not quite sure what you were trying to do. It appears you want a nested
transaction, which can only be accomplished with savepoints.
i was just 'testing' a bit with transactions (and savepoints),
in order to try to understand the question of Simon.
But it is still no very clear to /me what the meaning of his question
is/was.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
