In my application I have a certain process to perform test. This involves database with multi tables. I would like to know if it is possible to start a BEGIN;
to do all the manual development, and in case of error, to realize a ROLLBACK;
.
Note: Remember that they will be in separate moments, not in the same process, only with the same connection .
Example:
passo 1: "BEGIN;".
passo 2: processor manuais com form em html
passo 3: "ROLLBACK;" para re-teste;
I did not find many things about this type if situation and mostly it was recommended to cascade or Javascript validation, which is not possible.