From: | Steve News <earlysteve(at)earthlink(dot)net> |
---|---|
To: | "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>, pgsql-odbc(at)postgresql(dot)org |
Cc: | Michelle Murrain <mmurrain(at)dbdes(dot)com> |
Subject: | Re: Problems with ODBC and Access |
Date: | 2005-02-15 19:22:35 |
Message-ID: | 6.2.1.2.2.20050215141357.04fed818@pop.earthlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Eric E | 2005-02-15 19:42:38 | Re: Problems with ODBC and Access |
Previous Message | Joost Kraaijeveld | 2005-02-15 18:33:09 | Re: Problems with ODBC and Access |