Re: ODBC problem

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