On Wed, 29 Mar 2006, Tom Arthurs wrote:
> We are running into a strange problem -- one of our developers is extracting
> meta-data from our data base, and is seeing a difference in the data that is
> being returned. Columns typed as int or int4 are returning smallint from the
> meta-data information through jdbc, but if we go in and look at the tables
> through \d in the command line client, it is correctly typed as int. This
> started happening after we upgraded to 8.1.3 and after issuing alter table
> commands to create primary keys. (one data base was fine after the upgrade --
> yesterday, but today, after creation of primary keys, is now giving us the
> wrong int type).
>
> I'd like to know where jdbc is getting this information, so I can try to
> track down the cause.
>
The JDBC driver issues queries against the system catalogs. The best
thing you can do is send us a reproducible example of returning the wrong
type information. My attempt (attached) works fine here.
Kris Jurka