Re: Bug in DatabaseMetaData.getColumns(...)?? Patch applied

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>