Hi,
Environment :
Windows XP SP2 Postgres 8.0 JDK 1.5.0_02 postgresql-8.0-311.jdbc3.jar
While analysing the index structures of a metadata table with the following statement :
ResultSet parts = dbMeta.getIndexInfo("aCatalog", "aMetaSchema", "aTable", false, false);
...
if (parts != null) {
try {
while (parts.next()) { String indexName = parts.getString(6);
String columnName = parts.getString(9);
short position= parts.getShort(8);
String direction = parts.getString(10);
boolean unique = parts.getBoolean(4); }
} finally {
parts.close();
}
}
While controling the result with pgadmin III it appears that :
- Unique Index have a returned boolean unique set to false : - this value should apply to Non Unique Index - Non Unique Index have a returned boolean unique set to true : - this value should apply to Unique Index
Regards.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
