Skip site navigation (1) Skip section navigation (2)

Re: Access Autonumber fields not detected in 9.0.0200

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: arnaud(dot)listes(at)codata(dot)eu
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access Autonumber fields not detected in 9.0.0200
Date: 2011-03-04 15:35:16
Message-ID: 4D7106B4.1030602@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Arnaud,

Could you please try the drivers on testing for 9.0.0202 at
    http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue

(2011/03/04 18:18), Arnaud Lesauvage wrote:
> Hi Hiroshi
>
> Le 4/03/2011 9:49, Hiroshi Inoue a écrit :
>>> > We are linking PostgreSQL tables (server version 8.4) into Access
>>> 2000.
>>> > I tried upgrading our psqlodbc driver from 8.03.0400 to 9.00.0200, but
>>> > the autonumber fields (converted from serial fields) are not detected
>> Didn't you drop the *not null* attribute from the fields?
>
>
> No, it's still there. We didn't change anything but the psqlODBC driver.
> I tried to switch back and force from 8.03.0200 to 9.00.0200, and the
> field is linked as autonumer in v8 and numeric in v9.
>
> Here is part of the create table :
>
> CREATE TABLE codata.prestations
> (
> gid integer NOT NULL DEFAULT nextval('prestations_gid_seq'::regclass),
> [..., ]
> CONSTRAINT prestations_pkey PRIMARY KEY (gid)
> )
>
> Regards,
> Arnaud Lesauvage

In response to

Responses

pgsql-odbc by date

Next:From: Arnaud LesauvageDate: 2011-03-04 15:44:47
Subject: Re: Access Autonumber fields not detected in 9.0.0200
Previous:From: Arnaud LesauvageDate: 2011-03-04 09:18:42
Subject: Re: Access Autonumber fields not detected in 9.0.0200

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group