Adriano dos Santos Fernandes <adrian...@gmail.com> wrote Mon, 27 Aug 2018
20:10:49 +0300:
And when the user executes that EXECUTE BLOCK, all the whole thing may
execute repeated times.
So we cannot use any external routines with side effects anymore in
Firebird. Not even internal functions with side effects.
PROC2 has an autonomous transaction? Forget, now it can execute multiple
times.
External routines manipulating files? Forget, cannot do it anymore.
Some HTTP post/put called in a PSQL logic? No, we can't do it anymore.
Firebird is now limited to only manipulate data on the same transaction,
everything else may work or not anymore, depending if others users are
doing concurrent writes to some table.
Adriano,
I do not see any big problems with the restart of statements. Using
functions with a side effect in any case requires a very careful design.
Send mail from any procedure, the transaction of which will be rolled back
nothing better than sending mail twice.
__________________
Regards,
Simonov Denis
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
