Where does meta-data come from?

From: Tom Arthurs <tarthurs(at)jobflash(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Where does meta-data come from?
Date: 2006-03-29 22:13:48
Message-ID: 442B069C.3050203@jobflash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

TIA.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-03-29 22:29:29 Re: Where does meta-data come from?
Previous Message Markus Schaber 2006-03-29 11:11:34 Re: Printing query durations