From: | Thorsten Meinl <Thorsten(at)meinl(dot)bnv-bamberg(dot)de> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Bug in DatabaseMetaData.getColumns(...)?? |
Date: | 2002-11-29 23:01:29 |
Message-ID: | 3DE7F1C9.8070806@meinl.bnv-bamberg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
I just downloaded the new 7.3 release of PostgreSQL and also tried the
new JDBC-drivers shipped with the release. And I have problems with the
new driver.
The Java-API says for the function DatabaseMetaData.getColumns(...):
<snip>
Retrieves a description of table columns available in the specified
catalog.
Only column descriptions matching the catalog, schema, table and column
name criteria are returned. They are ordered by |TABLE_SCHEM|,
|TABLE_NAME|, and |ORDINAL_POSITION|.
</snip>
Looking in org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java I
find in line 2312 in getColumns(...)
<snip>
sql += " ORDER BY nspname,relname,attname ";
</snip>
So the order is wrong, the columns or sorted by their name and not by
their position in the table-defintion. This broke my code.
Is this a bug or an intended feature?
Greetings
Thorsten
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Nasser | 2002-11-29 23:59:13 | Re: Redhat 8 default database warning: JDBC problems (CLARIFICATION) |
Previous Message | Michael Ansley | 2002-11-29 19:35:22 | Re: JDBC for DataSource and Connection Pooling |