Re: Compatibility modes supported in ECPG - Mailing list pgsql-interfaces

From Ashutosh Sharma
Subject Re: Compatibility modes supported in ECPG
Date
Msg-id CAE9k0PneuT62kyqDbhEdeod3rd6PZiLJum=3S6Vo4f6-htSPUQ@mail.gmail.com
Whole thread Raw
In response to Re: Compatibility modes supported in ECPG  (Michael Meskes <meskes@postgresql.org>)
Responses Re: Compatibility modes supported in ECPG
List pgsql-interfaces
On Thu, Jan 11, 2018 at 4:34 PM, Michael Meskes <meskes@postgresql.org> wrote:
>> Thanks Michael. Shall i submit a patch for it. Also, what about
>
> Yes, please.
>

Thanks. Attached are the patches
'Allow_ecpg_to_throw_error_for_wrong_compat_modes_v1' and
'Allow_ecpg_to_throw_error_for_wrong_compat_modes_v2' that fixes the
reported issues.

>> making
>> the compatibility modes case insensitive. Currently, ecpg accepts
>> compatibility mode only in capital letters. In case if the INFORMIX
>> or
>> INFORMIX_SE is entered in small or mixed type letter, ecpg throws an
>> error. Shouldn't that be handled as well?
>
> Actually I don't mind either way. There is definitely an advantage of
> having it case insensitive, but then options are known to be case
> sensitive often enough.
>

I feel we should make them case insensitive. The reason being, other
embedded SQL programming languages for e.g. Pro*C accepts case
insensitive options. So, why can't we make our ecpg options case
insensitive as well. Thoughts?

--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com

> Michael
> --
> Michael Meskes
> Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
> Meskes at (Debian|Postgresql) dot Org
> Jabber: michael at xmpp dot meskes dot org
> VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL
>

Attachment

pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: Compatibility modes supported in ECPG
Next
From: Michael Meskes
Date:
Subject: Re: Compatibility modes supported in ECPG