pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Turning 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>
  2004-07-14 09:37 ` Re: Turning of case sensitivity for identifiers? Peter Eisentraut <peter_e@gmx.net>
  2004-07-14 14:16 ` Re: Turning of case sensitivity for identifiers? Stephan Szabo <sszabo@megazone.bigpanda.com>
  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 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>
  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 08:55 Turning of case sensitivity for identifiers? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
@ 2004-07-14 14:16 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
  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 09:53 Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
  2004-07-14 14:18 ` Re: Turning of case sensitivity for identifiers? Tom Lane <tgl@sss.pgh.pa.us>
  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 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>
  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