Postgres and case sensitivity

[Doug Easterbrook]

this comes up once in a while on the list --- and yes, postgres is case sensitive  but its never been a problem for us -- and omnis hasn't given grief.


all our table names and variable names in the database are created in lower case

all our variables and table names in omnis are all over the place as far as case sensitive goes.    For example, schema names in studio might look like   'fThisIsA_table'        in postgres, is is saved as  'fthisisa_table'.


in the $construct of the dam, we have set the following parameters on the dam:

Calculate $cinst.$emptydateisnull as kTrue
Calculate $cinst.$transactionmode as kSessionTranAutomatic
Calculate $cinst.$serializable as kFalse
Calculate $cinst.$readonly as kFalse
Calculate $cinst.$numericprecision as 17
Calculate $cinst.$sqlstripspaces as kFalse
Calculate $cinst.$sqlthousandseparator as ','     
Calculate $cinst.$sqldecimalseparator as '.'     
Calculate $cinst.$quotedidentifier as kFalse     ;; V92404 Studio 6 does it differently



and I have to say, we don't worry about case sensitivity at all within omnis --- ......      I think this is what you want.



Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 536-1205    Fax (403) 536-1210

On Aug 21, 2014, at 10:00 AM, omnisdev-en-request at lists.omnis-dev.com wrote:

> $Listers:
> 
> What is with Postgres and case sensitivity and how do you deal with it?