Access Autonumber fields not detected in 9.0.0200

Hi all !

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
anymore.
The connection string is the same (i.e. there is still the "0x2" extra
option to detect serial as autonumber).

I have pasted the debug log of the psqlodbc 9.00.0200 driver trying to
link the table (and failing to detect autonumber) here :
http://pastebin.com/aVRWFyJd

If you need any other information, I can do some testing.

Thanks a lot for your help !

Regards,
Arnaud Lesauvage

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Access Autonumber fields not detected in 9.0.0200

Hi Arnaud,

(2011/03/03 20:16), Arnaud Lesauvage wrote:
> Hi all !
>
> 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?

regards,
Hiroshi Inoue

> anymore.
> The connection string is the same (i.e. there is still the "0x2" extra
> option to detect serial as autonumber).
>
> I have pasted the debug log of the psqlodbc 9.00.0200 driver trying to
> link the table (and failing to detect autonumber) here :
> http://pastebin.com/aVRWFyJd
>
> If you need any other information, I can do some testing.
>
> Thanks a lot for your help !
>
> Regards,
> Arnaud Lesauvage


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Access Autonumber fields not detected in 9.0.0200

Hi Hiroshi

Le 4/03/2011 9:49, Hiroshi Inoue a =E9crit :
>> > We are linking PostgreSQL tables (server version 8.4) into Access 20=
00.
>> > I tried upgrading our psqlodbc driver from 8.03.0400 to 9.00.0200, b=
ut
>> > the autonumber fields (converted from serial fields) are not detecte=
d
> 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=20
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

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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 =E9crit :
>>> > 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 detect=
ed
>> 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

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Access Autonumber fields not detected in 9.0.0200

Le 4/03/2011 16:35, Hiroshi Inoue a =E9crit :
> Could you please try the drivers on testing for 9.0.0202 at
> http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/

I made a very quick test, and it looks very good !
I'll do some more testing next week.

Thanks a lot !

Regards,
Arnaud Lesauvage

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Access Autonumber fields not detected in 9.0.0200

Le 4/03/2011 16:35, Hiroshi Inoue a =E9crit :
> Could you please try the drivers on testing for 9.0.0202 at
> http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/

Hi Hiroshi

I can now confirm that this version works fine !
Do you have a release date for an MSI version of this driver ?

Thanks a lot !
Arnaud

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc