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

Re: Access Autonumber fields not detected in 9.0.0200

From: Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Access Autonumber fields not detected in 9.0.0200
Date: 2011-03-04 09:18:42
Message-ID: 4D70AE72.9050503@codata.eu (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2011-03-04 15:35:16
Subject: Re: Access Autonumber fields not detected in 9.0.0200
Previous:From: Hiroshi InoueDate: 2011-03-04 08:49:20
Subject: Re: Access Autonumber fields not detected in 9.0.0200

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