Runtime Config Option for identifier case preservation

From: Michael W Mitton <mmitton(at)ssi-c(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Runtime Config Option for identifier case preservation
Date: 2005-01-14 19:51:08
Message-ID: 200501141451.08412.mmitton@ssi-c.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Attached is a patch to allow the user to change the behavior of postgres with
reguards to case sensitivity on unquoted identifiers. This does not change
the default behavior of converting unquoted identifiers to lowercase, but
does allow (for instance, and I'm absolutly -not- pulling from personal
experience here <g>) a large project to run under postgres that did run under
MySQL a whole bunch easier.

for example, these two SQL statements sets are identical
set parser-ignore-case = false;
select "Address_id" from "Address";

set parser-ignore-case = true;
select Address_id from Address;

Attachment Content-Type Size
pg-parser-ignore-case.patch text/x-diff 2.5 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Michael W Mitton 2005-01-14 20:10:31 Re: Runtime Config Option for identifier case preservation
Previous Message Tom Lane 2005-01-14 17:54:00 Re: Minor comment correction