The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard

From: "David Delorme" <ddelorme(at)dmdelorme(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Date: 2003-03-12 14:44:48
Message-ID: b4nh4s$2tdd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-03-12 14:57:42 Re: Performance Problem
Previous Message Muhammad Shariq Muzaffar 2003-03-12 14:38:44 create function pl/pgsql c langauge