Re: DatabaseMetaData.getTables() doesn't sort its result

Patch applied for 7.2. Thanks.

> Hi,
>
> Here's an easy patch for todays snapshot to sort the result of the
>
> public ResultSet getTables(String catalog, String schemaPattern, String
> tableNamePattern, String[] types) throws SQLException
>
> method:
>
> Compare:
> (<)J:\postgresql-snapshot\src\interfaces\jdbc\org\postgresql\jdbc2\DatabaseMetaData.java
> (89441 bytes)
> with:
> (>)J:\postgresql-snapshot\src\interfaces\jdbc\org\postgresql\jdbc2\DatabaseMetaData.java.orig
> (89415 bytes)
>
> 1669c1669
> < sql.append("' order by relkind, relname");
> ---
> > sql.append("'");
>
> This is required by the JDBC spec: It says "They are ordered by TABLE_TYPE,
> TABLE_SCHEM and TABLE_NAME."
>
> <newbie>
> I was wondering while looking through the code why outer joins are not used
> for certain queries, e.g. in the getTables() method to get the comments for
> a particular table.
> </newbie>
>
>
> Cheers,
>
>
> Jeroen
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026