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(...):
> 
> 
> 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|.
> 
> 
> Looking in org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java I 
> find in line 2312 in getColumns(...)
> 
> 
> sql += " ORDER BY nspname,relname,attname ";
> 
> 
> 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