Re: Access Autonumber fields not detected in 9.0.0200 - Mailing list pgsql-odbc

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