From: David Delorme <ddelorme@dmdelorme.ca>
To: pgsql-sql@postgresql.org
Subject: The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Date: Wed, 12 Mar 2003 08:15:33 -0600
Message-ID: <PMEEIDMOLBOIEHAGBLOPMENKCAAA.ddelorme@dmdelorme.ca> (raw)
I am trying to integrate MapInfo with a postgresql backend.
Problem:
MapInfo query uses both quoted and unquoted statements i.e.
"MAPINFO"."MAPINFO_MAPCATALOG" and mapinfo.mapinfo_mapcatalog
I can not change the query statements that MapInfo uses to talk to the odbc
driver.
I am in the process of changing to grass5 for all my map production.
I have a schema called MAPINFO and a table called MAPINFO_MAPCATALOG.
I need to fold unquoted names to uppercase.
I really only need to change this behaviour for this schema.
David Delorme
http://dmdelorme.ca
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-sql@postgresql.org
Cc: ddelorme@dmdelorme.ca
Subject: Re: The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
In-Reply-To: <PMEEIDMOLBOIEHAGBLOPMENKCAAA.ddelorme@dmdelorme.ca>
* 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