.@Dmitry.
look at this like extension to feature. DBA set some timeout settings but 
developer can write those kind of trigger and take decision kill or cancell 
kill.
@Vlad
maybe inside trigger you can run command like:CANCEL_KILLREPEAT_AFTER time this 
is only proposition implementation details should be discussed
e.g. i see possibility to rwo kind of triggers and settingsDBA can set timeout 
sertings in firebird.conf or database.confDeveloper can set timeout by api 
before statement executionand this two situation can be threat different by two 
kind of triggers or inside trigger will be context var if this is by global 
settings or by api settings
and you are warry about trigger have enough knowledge - inside trigger you can 
have more info then in simple config settingsand remember post event ability
regards,Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: Dmitry Yemanov <[email protected]> 
Data: 18.08.2016  17:48  (GMT+01:00) 
Do: For discussion among Firebird Developers 
<[email protected]> 
Temat: Re: [Firebird-devel] RFC: Timeouts 

18.08.2016 13:04, liviuslivius wrote:
>
> I suppose better feature will be "timeout messaging" - something like
> TRIGGER ON STATEMENT_TIMEOUT
> TRIGGER ON TRANSACTION_TIMEOUT

Triggers are for developers. Asking DBAs to create special triggers is a 
bad idea.


Dmitry


------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to