Author: shawkins
Date: 2012-09-07 15:47:31 -0400 (Fri, 07 Sep 2012)
New Revision: 4409
Modified:
trunk/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java
Log:
TEIID-2166 being selective about the key types
Modified: trunk/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java
===================================================================
--- trunk/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java 2012-09-06
19:19:46 UTC (rev 4408)
+++ trunk/runtime/src/main/java/org/teiid/deployers/PgCatalogMetadataStore.java 2012-09-07
19:47:31 UTC (rev 4409)
@@ -166,7 +166,7 @@
"false as atthasdef " + //$NON-NLS-1$
"FROM (SYS.Keys as k INNER JOIN SYS.KeyColumns as kc ON k.uid = kc.uid INNER
JOIN SYS.Columns as t1 ON kc.SchemaName = t1.SchemaName AND kc.TableName = t1.TableName
AND kc.Name = t1.Name INNER JOIN " + //$NON-NLS-1$
"SYS.Tables as st ON st.Name = t1.TableName AND st.SchemaName = t1.SchemaName)
LEFT OUTER JOIN " + //$NON-NLS-1$
- "pg_catalog.matpg_datatype pt ON t1.DataType = pt.Name"; //$NON-NLS-1$
+ "pg_catalog.matpg_datatype pt ON t1.DataType = pt.Name WHERE k.type in
('Primary', 'Unique', 'Index')"; //$NON-NLS-1$
t.setSelectTransformation(transformation);
t.setMaterialized(true);
return t;
Show replies by date