Re: Bug in DatabaseMetaData.getColumns(...)?? Patch applied - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Bug in DatabaseMetaData.getColumns(...)?? Patch applied
Date
Msg-id 1039050759.2738.134.camel@inspiron.cramers
Whole thread Raw
In response to Bug in DatabaseMetaData.getColumns(...)??  (Thorsten Meinl <Thorsten@meinl.bnv-bamberg.de>)
List pgsql-jdbc
This has been patched in the current sources

Dave
On Fri, 2002-11-29 at 18:01, Thorsten Meinl wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC driver - first impressions and comments
Next
From: jguthrie@air.org
Date:
Subject: performance issues