Mark inactive triggers in SHOW command (add new column to its output)
---------------------------------------------------------------------
Key: CORE-4945
URL: http://tracker.firebirdsql.org/browse/CORE-4945
Project: Firebird Core
Issue Type: Improvement
Reporter: Pavel Zotov
Priority: Trivial
Currently one may detect that trigger is INactive only by extracting its
content. Command `show trigger' does not display such info neither in 2.5 nor
in 3.0:
SQL> show trigger;
Trigger name Invalid
================================ =======
TRG_CONNECT
Table name Trigger name Invalid
================================ ================================ =======
AGENTS AGENTS_BI
DOC_LIST DOC_LIST_AIUD
DOC_LIST DOC_LIST_BIUD
. . .
SQL> show trigger trg_connect;
TRG_CONNECT, Sequence: 0, Type: ON CONNECT, Inactive
Trigger text:
=============================================================================
as
begin
execute procedure sp_init_ctx;
. . . .
end
It will be useful to add information about INactive trigger(s) to the output of
SHOW TRIGGER command.
--
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
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
