From: Christopher R. Jones <cj@interlog.com>
To: Byron Nikolaidis <byronn@insightdist.com>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] postdrv ODBC driver problems
Date: Wed, 03 Mar 1999 13:58:07 -0500
Message-ID: <3.0.5.32.19990303135807.00936540@mail.interlog.com> (raw)
In-Reply-To: <36DD67C5.B252F75B@insightdist.com>
References: <36DCB277.498738E0@alef.gcsu.edu>
>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
I have always thought it strange that Access would allow field names with
mixed case and spaces. I come from the Foxbase side and Visual Foxpro has
maintained the tradition of lower case, no space field names. It
simplifies things to stick to one naming convention that works for all
databases.
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: cj@interlog.com, byronn@insightdist.com
Subject: Re: [INTERFACES] postdrv ODBC driver problems
In-Reply-To: <3.0.5.32.19990303135807.00936540@mail.interlog.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