Zlatko Matić schrieb:
> several columns! You must use non-floating NUMERICAL field (long) as
> key. The best is to use autoincrement (BIGSERIAL) field as primary key.
> So, add bigserial fields to all your tables, make them primary keys
> and it
> will solve your problems with "#Deleted".
BIGserials are 8 byte integers.
Access can handle only 4 byte integer fields. The ODBC driver maps the
bigints down to 4 bytes as default setting.
If Access can't actually use the additional 4 bytes why bloat the tables
and add maintenance work to the driver?
It's all fine if your bigserials stay small enough.
Access "Long Integer" are signed and therefore range from
-2.147.483.648 to 2.147.483.647.
That matches "integer" in PG.
In response to
pgsql-odbc by date
|Next:||From: Zlatko Matić||Date: 2005-07-25 14:58:56|
|Subject: Re: psqlodbc-08_00_0101 does not work with Ms Access|
|Previous:||From: Joel Fradkin||Date: 2005-07-25 13:25:16|
|Subject: Re: Blank varchar and text fields|