DatabaseMetaData.getTables problem

Поиск
Список
Период
Сортировка
От snpe
Тема DatabaseMetaData.getTables problem
Дата
Msg-id 200211072222.57311.snpe@snpe.co.yu
обсуждение исходный текст
Ответы possible memory leak??
Список pgsql-jdbc
Hello,
  I am playing with DatabaseMetaData.getTables
I call getTables(null,null,"TABELA",null)

ResultSet get (number of column of TABELA)+ 1 rows

Patch for this problem is :
---
/u2/postgrescvs/pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
2002-11-04 12:03:04.000000000 +0000
+++ org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java    2002-11-07
22:11:11.000000000 +0000
@@ -1988,7 +1988,7 @@
             " END "+
             " AS TABLE_TYPE, d.description AS REMARKS "+
             " FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c "+
-            " LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid) "+
+            " LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid and
d.objsubid = 0) "+
             " LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND
dc.relname='pg_class') "+
             " LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND
dn.nspname='pg_catalog') "+
             " WHERE c.relnamespace = n.oid ";


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "David Hooker"
Дата:
Сообщение: Re: Query Executor Problem
Следующее
От: Dave Cramer
Дата:
Сообщение: possible memory leak??