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

Possible bug in Insight PostGres ODBC driver

From: Chris Wilson <cmw32(at)cam(dot)ac(dot)uk>
To: byronn(at)insightdist(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Possible bug in Insight PostGres ODBC driver
Date: 1998-12-10 10:40:29
Message-ID: Pine.SOL.3.95q.981210103426.10350B-100000@red.csi.cam.ac.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi Byron,

I think I have found a bug in Insight's ODBC Driver for PostGres. When you
export data containing backslashes from Access, they are not escaped in
the SQL statement, and the resulting statement either contains unintended
escape codes, or, if the backslash is the last character in the field, it
accidentally escapes the trailing ' which causes PostGres to fail with a
parser error. I'm not sure whether backslashes are allowed in ODBC
requests, and if not then this is a bug in Access, but it would be very
helpful if the driver could detect and correct this problem anyway since
it took us nearly a full day to diagnose and others might find it
impossible and give up on PostGres :-(.

Cheers, Chris.
   ___ __     _  
 / __// / ,__(_)_  | Chris Wilson <Chris(dot)Wilson(at)fitz(dot)cam(dot)ac(dot)uk> Unix+Net+RC5 |
/ (_ / ,\/ _/ /_ \ | We are GNU. Microsoft is futile. It will be assimilated |
\__//_/_/_//_/___/ +-- If you think education is expensive, try ignorance. --+

"Since UNIX is a complex system, it takes a complex person to understand it"
- Bryant (BOFH) http://www.bofh.net/lisa/quotes.html


pgsql-interfaces by date

Next:From: Laurent DELVAUXDate: 1998-12-10 10:42:18
Subject:
Previous:From: Marcio MacedoDate: 1998-12-10 09:51:42
Subject: Re: your mail

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