details: https://code.openbravo.com/erp/devel/pi/rev/861d5861059e changeset: 17973:861d5861059e user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Tue Sep 18 15:22:53 2012 +0200 summary: Fixes issue 21655: The alert to check disabled triggers does not work
diffstat: src-db/database/model/prescript-PostgreSql.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r 4e6bdb057dbd -r 861d5861059e src-db/database/model/prescript-PostgreSql.sql --- a/src-db/database/model/prescript-PostgreSql.sql Fri Sep 14 14:21:28 2012 +0200 +++ b/src-db/database/model/prescript-PostgreSql.sql Tue Sep 18 15:22:53 2012 +0200 @@ -1292,7 +1292,7 @@ CREATE OR REPLACE VIEW USER_TRIGGERS (TABLE_NAME, TABLESPACE_NAME, TRIGGER_NAME, STATUS) AS -SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_NAMESPACE.NSPNAME), PG_TRIGGER.TGNAME, 'ENABLED'::text +SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_NAMESPACE.NSPNAME), PG_TRIGGER.TGNAME, CASE WHEN pg_trigger.tgenabled = 'D'::"char" THEN 'DISABLED'::text ELSE 'ENABLED'::text END AS status FROM PG_TRIGGER, PG_CLASS, PG_NAMESPACE WHERE PG_TRIGGER.tgrelid = PG_CLASS.OID AND PG_CLASS.RELNAMESPACE = PG_NAMESPACE.OID ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
