[teiid-commits] teiid SVN: r2653 - branches/7.1.x/console/src/main/java/org/teiid/rhq/plugin/util.

Author: tejones Date: 2010-10-14 12:21:44 -0400 (Thu, 14 Oct 2010) New Revision: 2653 Modified: branches/7.1.x/console/src/main/java/org/teiid/rhq/plugin/util/PluginConstants.java Log: TEIID-982: Added ODBC mat view filter to MATVIEW query Modified: branches/7.1.x/console/src/main/java/org/teiid/rhq/plugin/util/PluginConstants.java =================================================================== --- branches/7.1.x/console/src/main/java/org/teiid/rhq/plugin/util/PluginConstants.java 2010-10-14 15:54:18 UTC (rev 2652) +++ branches/7.1.x/console/src/main/java/org/teiid/rhq/plugin/util/PluginConstants.java 2010-10-14 16:21:44 UTC (rev 2653) @@ -232,7 +232,8 @@ public static interface Value { public final static String STOP_NOW = "stopNow"; //$NON-NLS-1$ public final static String MAT_VIEW_QUERY = "select SchemaName, Name, TargetSchemaName, TargetName, " + //$NON-NLS-1$ - "Valid, LoadState, Updated, Cardinality from SYSADMIN.MATVIEWS"; //$NON-NLS-1$ + "Valid, LoadState, Updated, Cardinality from SYSADMIN.MATVIEWS " + //$NON-NLS-1$ + "where SchemaName != 'pg_catalog'"; //$NON-NLS-1$ public final static String MAT_VIEW_REFRESH = "exec SYSADMIN.refreshMatView('param1','param2');"; //$NON-NLS-1$ public final static String WAIT_UNTIL_FINISHED = "waitUntilFinished"; //$NON-NLS-1$