[JDBC] Fix for broken JDBC's getColumn() (take 2)

2001-09-10 Thread Jeroen van Vianen
Hi, Per the recent discussion there's been some code changes in JDBC's DatabaseMetaData.getColumn(). I proposed a patch that would change the number of queries to find out all columns in a table from 2 * N + 1 to 1 (N being the number of columns reported) by using some outer joins. I also fix

Re: [JDBC] [HACKERS] JDBC pg_description update needed for CVS

2001-09-09 Thread Jeroen van Vianen
At 00:18 9/9/2001 +0200, Rene Pijlman wrote: >On Fri, 07 Sep 2001 01:34:46 -0400, Tom Lane wrote: > >there is still an unpatched reference to pg_description in > >getColumns(), in both jdbc1 and jdbc2. > >This was introduced by Jeroen's patch (see >http://fts.postgresql.org/db/mw/msg.html?mid=1032

Re: [JDBC] [HACKERS] JDBC pg_description update needed for CVS

2001-09-07 Thread Jeroen van Vianen
At 00:30 9/7/2001 -0400, Bruce Momjian wrote: >Can someone tackles this and supply a patch? This has been addressed in the patch that was recently committed for JDBC's broken getColumn() support. As I'm using outer joins and was unable to come up with SQL syntax that would correctly use an oute

[JDBC] Patch for broken JDBC's getColumn()

2001-08-30 Thread Jeroen van Vianen
Hi, Attached is a patch for JDBC's getColumn() function that was broken / flawed in the following ways: 1. Only returned columns that had a default value defined, rather than all columns in a table 2. Used 2 * N + 1 queries to find out attributes, comments and typenames for N columns. By usi

[JDBC] Patch for broken JDBC's getColumn()

2001-08-28 Thread Jeroen van Vianen
Hi, Attached is a patch for JDBC's getColumn() function that was broken / flawed in the following ways: 1. Only returned columns that had a default value defined, rather than all columns in a table 2. Used 2 * N + 1 queries to find out attributes, comments and typenames for N columns. By usi

[JDBC] DatabaseMetaData.getTables() doesn't sort its result

2001-03-07 Thread Jeroen van Vianen
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\DatabaseMet