pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Byron Nikolaidis <byronn@insightdist.com>
To: Ben Gunter <bgunter@alef.gcsu.edu>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Cc: David Hartwig <daybee@bellatlantic.net>
Subject: Re: [INTERFACES] postdrv ODBC driver problems
Date: Wed, 03 Mar 1999 11:48:06 -0500
Message-ID: <36DD67C5.B252F75B@insightdist.com> (raw)
References: <36DCB277.498738E0@alef.gcsu.edu>
Ben Gunter wrote:
> After version 0.95 of PgAccess was released (thanks so much for the
> quick response!), I figured my problems with character case were
> resolved. Unfortunately, I tried to use the ODBC driver with MS Excel
> 97, and encountered the same problem. Tables with mixed case field
> names gave me errors, and tables with all lower case field names worked.
>
> MS Query could see the table fine (named "Present") and reported the
> names of the fields fine ("First Name" and "Last Name"), but it failed
> when I actually executed the query. It said: func_get_detail: no such
> attribute or function "lastname".
>
Yes, it is a known problem with mixed case. Some Microsoft apps don't
bother to use quotes around table/field names to preserve the case, I guess
cause they assume that every dbms works like Microsoft SQL server. MSAccess
however does always use quotes so mixed case names are no problem with
MSAccess.
I'm not really sure how to proceed on this one. Maybe you could just use
all lower case names for now.
It would seem to me that if an identifier (table/field name) is not quoted
in an sql statement, then Postgres should not care about the case and match
on it. That to me seems like the correct approach.
Any opinions?
Byron
view thread (4+ messages) latest in thread
Message-ID: <36DD67C5.B252F75B@insightdist.com> Permalink: ../36DD67C5.B252F75B@insightdist.com/ Also on: postgresql.org/message-id/36DD67C5.B252F75B@insightdist.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-interfaces@postgresql.org Cc: byronn@insightdist.com, bgunter@alef.gcsu.edu, daybee@bellatlantic.net Subject: Re: [INTERFACES] postdrv ODBC driver problems In-Reply-To: <36DD67C5.B252F75B@insightdist.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox