On Tue, 1 Aug 2006, flash.xu wrote:
Bug reference: 2559 PostgreSQL version: 8.1.4 Description: why jdbc-driver AbstractJdbc2ResultSetMetaData. getTableName(int column) return "" Details: I'm using jdbc3 8.1 to build my java project.But when I use ResultSetMetaData class to get table'name,the result is ""! I check the jdbc8 8.1's source code,and found the AbstractJdbc2ResultSetMetaData. getTableName(int column) return "". Instead, the method of "getBaseTableName()" return the real table'name. Similar,the method of"getColumnName()"return the column'lable,but the method of"getColumnName()" return the real column'name. please show why?thanks. My project has been used Oracle and Mysql.It's my first to use PostgreSQL.
Please see the thread "Wrong column names in ResultSetMetaData" http://archives.postgresql.org/pgsql-jdbc/2004-08/threads.php#00008 Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match