Re: Cluster wide option to control symbol case folding

From: Craig Ringer <craig(dot)ringer(at)2ndquadrant(dot)com>
To: "Lewis, Ian (Microstar Laboratories)" <ilewis(at)mstarlabs(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Cluster wide option to control symbol case folding
Date: 2016-12-25 05:52:18
Message-ID: CAMsr+YGTCSDPmZeXK5s0WaYoKmDMXoEe8GWDBZooyozd7yJ8tQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 25 Dec. 2016 10:30 am, "Lewis, Ian (Microstar Laboratories)" <
ilewis(at)mstarlabs(dot)com> wrote:

Is there any chance that the PostgreSQL developers would accept a new
cluster wide configuration option to control how the system handles
symbol case folding?

Probably not as a GUC (configuration option, like in PostgreSQL.conf).
There's a somewhat established principle that GUCs should not change query
semantics.

Personally I can see such an option being ok as an initdb-time setting or
at CREATE DATABASE time. Case folding can know the current db from global
context.

It'd have to be fast though. Very fast.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-12-25 06:48:36 Re: Cluster wide option to control symbol case folding
Previous Message Lewis, Ian (Microstar Laboratories) 2016-12-25 02:29:02 Cluster wide option to control symbol case folding