Re: Problem with the PGSQL-ODBC driver and MS Access

At 18:44 26/04/2006, you wrote:
>Hi,
>I have a user who has been converting some data from access to a
>Postgresql 8.1.3 backend and we ran into
>a issue where some records would show up in Access with all the fields
>as #deleted

I've seen this sometimes when using "timestamp": access doesn't
understand well the fractionnal part of it. You should instead use
timestamp(0).

db=> create temp table zz ( field1 timestamp(0), field2 timestamp );
CREATE TABLE
db=> insert into zz values (now(),now());
INSERT 0 1
db=> select * from zz ;
field1 | field2
---------------------+----------------------------
2006-04-26 22:44:42 | 2006-04-26 22:44:41.893001
(1 row)

----------------------------------------------------------
field1 will be understandable by access, not field2.
msaccess in that case will show "deleted" in all cells.

hopes that help . P.