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: 42126E37.8010805@bonbon.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Steve,
    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 
Versioning...

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

EE


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: www.askesis.nl
>>
>> ---------------------------(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-2014 The PostgreSQL Global Development Group