timer trigger
-------------
Key: CORE-4052
URL: http://tracker.firebirdsql.org/browse/CORE-4052
Project: Firebird Core
Issue Type: New Feature
Affects Versions: 3.0 Alpha 1, 3.0 Beta 1, 3.0.0
Environment: all
Reporter: Holger Klemt
Since the database triggers and the autonomous transactions are already
extremly useful, it would be nice to have a new trigger type, which is
initiated by the engine itself based on timer rules.
Syntax could be
CREATE OR ALTER trigger "_BI0"
active on timer_every_minute position 0
AS
begin
/* Trigger text */
end
the engine could simply initiate the trigger and execute it, as if it would be
execute as a database trigger initiated by a isql connect.
if any operation is done by this timertrigger, it can be a rule that this can
only be done using execute statement ... as user ... password .. to have
a user and transaction context
other options could be timer_every_minute, timer_every_second, timer_every_day
(initiated when current_date changes) etc.
>From my perspective these changes will use a lot of existing code and will
>give Firebird3 a very helpful new feature
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The Go Parallel Website, sponsored by Intel - in partnership with Geeknet,
is your hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials, tech docs,
whitepapers, evaluation guides, and opinion stories. Check out the most
recent posts - join the conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
