Re: #Deleted - Mailing list pgsql-odbc

From Henshall, Stuart - Design & Print
Subject Re: #Deleted
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E0506DC81@MAIL_EXCHANGE
Whole thread Raw
In response to #Deleted  ("Alain Remont" <alain.remont@phenomix.com.au>)
List pgsql-odbc

Alain Remont wrote:
> Have just installed ODBC on a Windows XP machine which talks to a
> Debian Linux PostgreSQL server. The idea is to access some tables on
> the server from MS Access in the XP m/c.
>
> I have a test PostgreSQL database. I manage to connect and list the
> tables. However, when I try to view the tables, a few get filled with
> "#Deleted". The strange thing is that "some" tables load absolutely
> correctly, but several of them do not: they get a series (correct
> number) of rows filled with the string "#Deleted". Oh, the column
> names are also correct.
>
> Is there some simple explanation?
>
> From looking at the tables, I cannot find a "common thread" as to why
> certain tables do not load across.
>
> Would appreciate any pointers.....
>
> A
>
As a quick stab in the dark I'd guess that some sort of truncation occurs in the comparision (either floats or timestamps) so that it thinks that these rows have changed. I use row versioning with access and this seems to have worked well for me (although admittedly I don't tend to use raw tables or datasheets).

- Stuart

pgsql-odbc by date:

Previous
From: "Alain Remont"
Date:
Subject: #Deleted
Next
From: "Robert John Shepherd"
Date:
Subject: Known bugs in OBDC?