| From: | Xavier Maysonnave <xavier(at)omondo(dot)com> | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Subject: | jdbc driver return wrong medata values | 
| Date: | 2005-04-14 16:03:52 | 
| Message-ID: | 425E9468.4000701@omondo.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Behrens | 2005-04-14 20:10:39 | BUG #1597: pg_dump --verbose ignores --disable-triggers | 
| Previous Message | Guilherme Paiva Santos | 2005-04-14 00:48:25 | BUG #1596: Bad header in input lib |