Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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: pg-parser-ignore-case.patch
Description: text/x-diff (2.5 KB)


pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group