Re: MSACCESS & Apostrophe in Column Name

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Bob Woodside" <proteus(at)pcnet(dot)com>
Cc: "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: MSACCESS & Apostrophe in Column Name
Date: 2001-06-16 01:05:52
Message-ID: EKEJJICOHDIEMGPNIFIJOEOOEKAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Bob Woodside wrote:
>
>
> Here's a curious problem. We recently exported an Access table to
> PostgreSQL. The table has 3 column names containing apostrophes (or
> single-quotes, if you like). This seems to confuse some bit of parsing
> logic somewhere in the ODBC path, whenever a dynaset query is sent from
> Access that has an odd number of references to these apostrophic names.
>
> If we issue a query with an odd number of these references, the
back
> end receives something like this:
>
> > 'SELECT "ID","Month called or rec'd form","FullName" FROM
"GHI-practice2"
> > WHERE "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID"
= ?
> > OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ?'
>

Psqlodbc driver has been unaware of double-quotes(") .
Probably it's the cause.
Recently I changed the driver to check double-quotes.
Could you try the CVS snapshot ?

regards,
Hiroshi Inoue

> which, of course, it rejects.
>
> If we issue a query with an even number of such references, the
back
> end receives something like this, and is very happy:
>
> > SELECT "ID","Month called or rec'd form","Day called or rec'd
form","FullName"
> > FROM "GHI-practice2" WHERE "ID" = 1 OR "ID" = 3 OR "ID" = 4 OR "ID" =
6
> > OR "ID" = 8 OR "ID" = 9 OR "ID" = 11 OR "ID" = 12 OR "ID" = 13 OR "ID"
= 14'
>
> I've captured traces from the ODBC manager and from the pgsql
driver,
> and can forward them if you like. I haven't yet had time to try to dig
> into this any deeper to determine whether the bug is in the Postgres
> driver or in MS code.
>
> Has anyone got any idea where the problem lies? Is it a known
problem
> with a known workaround, or a new, um, opportunity?
>
> Cheers,
> Bob

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-06-16 01:06:01 Re: SQLConnect Core dump with Purify
Previous Message Johann Zuschlag 2001-06-15 17:47:13 Re: slow performance postgres 7.0.3 and odbc