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

["Greg Cocks" <gcocks(at)stoller(dot)com>]

-----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