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

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

----- "drbob" <drbob(at)gmx(dot)co(dot)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(at)comcast(dot)net

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

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

Regards,
GREG COCKS
gcocks(at)stoller(dot)com