Re: ODBC problem - Mailing list pgsql-interfaces

From Hiroshi Inoue
Subject Re: ODBC problem
Date
Msg-id 3B257E30.8171C119@tpf.co.jp
Whole thread Raw
In response to ODBC problem  (Simon Emmanuel Rivas <simon-emmanuel.rivas@isr.thomson-csf.com>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Vincent Roberts
Date:
Subject: Calling lo_open within user defined C function
Next
From: Alex Pilosov
Date:
Subject: Re: How to determine PRIMARY KEYS