Thread: ODBC problem

Hi!

I have a problem using the ODBC interface. The problem is quite simple:
I have created a table with only one field, as follows:create table test (key numeric(1));
Very simple, right? The problem is that, when I look at this table
through a client program which runs under Windows (postgres runs under
Linux), the field "key" seems to be declared as numeric(3).
Does the problem come from ODBC or the client program?
Thanx for your help!

PS: the client program is Data Factory from Quest Software. I use
Postgres 7.1.1 and the ODBC driver is v7.01.0005.

Simon Emmanuel Rivas wrote:
> 
> Hi!
> 
> I have a problem using the ODBC interface. The problem is quite simple:
> I have created a table with only one field, as follows:
>         create table test (key numeric(1));
> Very simple, right? The problem is that, when I look at this table
> through a client program which runs under Windows (postgres runs under
> Linux), the field "key" seems to be declared as numeric(3).
> Does the problem come from ODBC or the client program?

The problem seems to come from the client program.
For example, M$ Access recognizes numeric(1).

regards,
Hiroshi Inoue