Re: Access Autonumber fields not detected in 9.0.0200

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