Skip site navigation (1) Skip section navigation (2)

Re: Problems with ODBC and Access

From: Eric E <whalesuit(at)bonbon(dot)net>
To: Steve News <earlysteve(at)earthlink(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org, Michelle Murrain <mmurrain(at)dbdes(dot)com>
Subject: Re: Problems with ODBC and Access
Date: 2005-02-15 21:48:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
    I don't really understand the internals,  but is the integer being 
searched in the where clause by chance "xmin"?  I believe this is how 
the ODBC driver figures out the appropriate row to return to Access - at 
the very least it's what appears in linked tables when you enable Row 

Also, does the log stuff vary when you use different versions of the driver?


Steve News wrote:

> Joost,
> I'm going to jump in here. I work with Michelle, but am having trouble 
> posting to the pg list. When we look at the log files, some times we 
> see strange things. I don't have them handy to cut and past here, but 
> for example, I can request all rows from a table (no "where" clause"). 
> Then in the log, I may see three queries. The first is correct. Then, 
> there are two that on their own have added a where clause that 
> restricts the data by saying record_id = {some random big integer 
> having nothing to do with nothing}. Then the table opens with every 
> dell filled with #delete#.
> --steve backman
> At 2/15/2005 01:33 PM, you wrote:
>> Hi Michelle,
>> Did you look at the log files that the ODBC drivers generates (if 
>> turned on) and/or the PostgresQL log files?
>> Groeten,
>> Joost Kraaijeveld
>> Askesis B.V.
>> Molukkenstraat 14
>> 6524NB Nijmegen
>> tel: 024-3888063 / 06-51855277
>> fax: 024-3608416
>> e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
>> web:
>> ---------------------------(end of broadcast)---------------------------
>> TIP 8: explain analyze is your friend
>> -- 
>> No virus found in this incoming message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.306 / Virus Database: 265.8.8 - Release Date: 2/14/2005
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

In response to

pgsql-odbc by date

Next:From: Philippe LangDate: 2005-02-16 11:08:09
Subject: Re: Problems with ODBC and Access
Previous:From: Eric EDate: 2005-02-15 19:42:38
Subject: Re: Problems with ODBC and Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group