27.08.2018 13:55, Adriano dos Santos Fernandes wrote:
On 27/08/2018 03:30, Vlad Khorsun wrote:
If it is not what you asked for - please, explain the question.
What if a PSQL request calls an UDF/UDR, then executes a SELECT/UPDATE
that triggers a retry, will the UDF/UDR (that is not in the
SELECT/UPDATE, but in previous PSQL logic) will be executed again?
Whole execution tree, starting from top-level request, will be executed again
within new snapshot. So, yes, that UDF\UDR will be also executed again, unless
control flow changed its path because of new data visible within new snapshot.
Regards,
Vlad
------------------------------------------------------------------------------
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
