The following bug has been logged online: Bug reference: 1521 Logged by: Sergio Lob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux Description: precision column value returned from getTypeInfo() always value of 9 Details:
After calling Connection.DatabaseMetaData.getTypeInfo() method, the PRECISION column of the ResultSet seems hardcoded to value 9. To repro: 1. connect to a PostgresSQL JDBC data source 2. Invoke Connection.getMetaData() on that connection to get DatabaseMetaData object 3. Invoke DataBaseMetaData.getTypeInfo() to get ResultSet of all supported data types 4. Invoke ResultSet.next() to get to first row 5. Invoke ResultSet.getString(3) to get PRECISION column value for current row. Notice that no matter what row is checked in the answer set, precision of data type is ALWAYS 9. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
