BUG #1521: precision column value returned from getTypeInfo() always value of 9

From: "Sergio Lob" <sergio_lob(at)iwaysoftware(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1521: precision column value returned from getTypeInfo() always value of 9
Date: 2005-03-03 17:36:54
Message-ID: 20050303173654.3846EF1537@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1521
Logged by: Sergio Lob
Email address: sergio_lob(at)iwaysoftware(dot)com
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.

Browse pgsql-bugs by date

  From Date Subject
Next Message DIEGO URRA 2005-03-03 19:15:27 BUG #1522: there's a syntax error using psql, distinct
Previous Message Ivan Chumak 2005-03-03 08:51:24 BUG #1520: messages in Russian is made wrong