01.03.2017 9:33, Karol Bieniaszewski (JIRA) wrote:
> Add context variable about transaction start timestamp
> ------------------------------------------------------
>
>                  Key: CORE-5493
>                  URL: http://tracker.firebirdsql.org/browse/CORE-5493
>              Project: Firebird Core
>           Issue Type: New Feature
>           Components: Engine
>             Reporter: Karol Bieniaszewski
>
>
> Please add to context variables transaction start timestamp
> CURRENT_TRANSACTION_START_TIME
>
> something like other context variables CURRENT_TRANSACTION, CURRENT_TIME
> It is usefull for e.g. audit - to have whole transaction operations marked 
> with same timestamp.
>
> We can use Select from MON$ tables now, but it cause performance drop - also 
> if included in TRANSACTION START trigger

   Is there any objection to add it into upcoming v3.0.2 and v4 ?

As for the name, i prefer CURRENT_TRANSACTION_TIME or 
CURRENT_TRANSACTION_TIMESTAMP.
Comments ?

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

Reply via email to