Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5BDYOE78877 for ; Mon, 11 Jun 2001 09:34:24 -0400 (EDT) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from gwsmtp.thomson-csf.com (gwsmtp.thomson-csf.com [195.101.39.226]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5786ME79705 for ; Thu, 7 Jun 2001 04:06:24 -0400 (EDT) (envelope-from simon-emmanuel.rivas@isr.thomson-csf.com) Received: from thomplex.thomson-csf.com (200.3.2.2) by gwsmtp.thomson-csf.com (NPlex 5.1.053) id 3B1E908C00006A3C for pgsql-interfaces@postgresql.org; Thu, 7 Jun 2001 10:11:23 +0200 Received: from thomplex.thomson-csf.com (200.3.2.2) by thomplex.thomson-csf.com (NPlex 5.1.053) id 3B1C6AF20003F7AA for pgsql-interfaces@postgresql.org; Thu, 7 Jun 2001 10:06:06 +0200 Received: from isr.thomson-csf.com (172.18.61.24) by isrplex.isr.thomson-csf.com (NPlex 5.1.053) id 3B0A25250000ECD5 for pgsql-interfaces@postgresql.org; Thu, 7 Jun 2001 10:06:05 +0200 Message-ID: <3B1F3638.79D8E4B8@isr.thomson-csf.com> Date: Thu, 07 Jun 2001 10:07:20 +0200 From: Simon Emmanuel Rivas Organization: ISR X-Mailer: Mozilla 4.75 [fr] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: ODBC problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/43 X-Sequence-Number: 1705 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.