| From: | snpe <snpe(at)snpe(dot)co(dot)yu> | 
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> | 
| Subject: | DatabaseMetaData.getTables problem | 
| Date: | 2002-11-07 22:22:57 | 
| Message-ID: | 200211072222.57311.snpe@snpe.co.yu | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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 ";
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-11-08 13:11:45 | possible memory leak?? | 
| Previous Message | postgres | 2002-11-07 21:12:09 | PostgresqlDataSource |