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-sql(at)postgresql(dot)org>
Subject: The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Date: 2003-03-11 19:39:10
Message-ID: PMEEIDMOLBOIEHAGBLOPOENFCAAA.ddelorme@dmdelorme.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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 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

Browse pgsql-sql by date

  From Date Subject
Next Message Terry Lee Tucker 2003-03-11 20:46:14 Re: Novice needs help
Previous Message Terry Lee Tucker 2003-03-11 17:47:37 Novice needs help