pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTurning of case sensitivity for identifiers?
5+ messages / 4 participants
[nested] [flat]
* Turning of case sensitivity for identifiers?
@ 2004-07-14 08:55 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 2 replies; 5+ messages in thread
From: Joost Kraaijeveld @ 2004-07-14 08:55 UTC (permalink / raw)
To: pgsql-admin
Hi all,
Is it possible to turn of the case sensitivity for tables and columns in queries (to all CAPS)? I have a (closed source) tool that I have to use (Clarion) that generates the queries and I cannot change the way the tool generates the queries.
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Turning of case sensitivity for identifiers?
@ 2004-07-14 09:37 Peter Eisentraut <peter_e@gmx.net>
parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
1 sibling, 0 replies; 5+ messages in thread
From: Peter Eisentraut @ 2004-07-14 09:37 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: pgsql-admin
Am Mittwoch, 14. Juli 2004 10:55 schrieb Joost Kraaijeveld:
> Is it possible to turn of the case sensitivity for tables and columns in
> queries (to all CAPS)? I have a (closed source) tool that I have to use
> (Clarion) that generates the queries and I cannot change the way the tool
> generates the queries.
The table and column names are not actually case sensitive; they are just
folded to lower case while you apparently expect upper case. If you write
the names the same way in each command, there should not be a problem. What
problem are you actually seeing?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Turning of case sensitivity for identifiers?
@ 2004-07-14 09:53 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 1 reply; 5+ messages in thread
From: Joost Kraaijeveld @ 2004-07-14 09:53 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
Hi Peter,
Peter Eisentraut schreef:
> The table and column names are not actually case sensitive;
> they are just folded to lower case while you apparently expect upper case.
I am unsure of the translation of "fold". Is that the same as translate? Does that mean that if Postgresql get a query without quotes it translates the schema/column/table to lower case automatically?
> If you write the names the same way in each command, there should not be a
> problem.
I cannot see how Clarion creates the queries. I have to deduct it from a log file that does not show me the query as-is but gives a "user friendly" translation of the query, without any quotes.
> What problem are you actually seeing?
Clarion checks whether the table is valid. For that, it seems to do an ODBC SQLColumns which returns the schema/table/column name in lower case while Clarino is expecting it to be uppercase. Hence it says that the table is not valid (it seems to find the table but not the columns). On a DB2 database (that has all caps names) it works.
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Turning of case sensitivity for identifiers?
@ 2004-07-14 14:16 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
1 sibling, 0 replies; 5+ messages in thread
From: Stephan Szabo @ 2004-07-14 14:16 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: pgsql-admin
On Wed, 14 Jul 2004, Joost Kraaijeveld wrote:
> Is it possible to turn of the case sensitivity for tables and columns in
> queries (to all CAPS)? I have a (closed source) tool that I have to use
> (Clarion) that generates the queries and I cannot change the way the
> tool generates the queries.
It's not currently possible to turn off case folding or to force spec
complient upper case folding. You may want to look through the archives
for the discussions if you wish to add something.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Turning of case sensitivity for identifiers?
@ 2004-07-14 14:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2004-07-14 14:18 UTC (permalink / raw)
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-admin
"Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl> writes:
> I cannot see how Clarion creates the queries.
That's easily fixed. Turn on log_statement in postgresql's
configuration file and look at the server-side log to see what Clarion
is sending.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-07-14 14:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-14 08:55 Turning of case sensitivity for identifiers? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2004-07-14 09:37 ` Peter Eisentraut <peter_e@gmx.net>
2004-07-14 14:16 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-07-14 09:53 Re: Turning of case sensitivity for identifiers? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
2004-07-14 14:18 ` Tom Lane <tgl@sss.pgh.pa.us>
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