Re: MS access and postgres "#Deleted" appearing after inserts

-----Original Message-----
From: Adrian Klaver [mailto:aklaver@comcast.net]
Sent: Friday, March 13, 2009 4:33 PM
To: drbob
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] MS access and postgres "#Deleted" appearing after inserts


----- "drbob" <drbob@gmx.co.uk> wrote:

> Hello,
>
> I recently experienced the following issue using MS access as an ODBC
>
> connected frontend to a postgreSQL database:
>
> Upon inserting a new row Access then displays every field in the row
> as
> "#Deleted". However the insert has not failed, re-querying the table
> displays the newly inserted row.

[snip]

>
> Any comments or suggestions welcome.
>
> regards,
>
> drbob
>

* You don't by chance have a timestamp field in the Postgres table? I have
* seen this when the timestamp field has millisecond precision. Access has
* problems with that. To solve I set timestamps to timestamp(0).

* Adrian Klaver
* aklaver@comcast.net


--------------------------


I has a similar problems with special characters - like using ß instead of beta or somesuch...

Regards,
GREG COCKS
gcocks@stoller.com