Re: Multi-byte character case-folding

On Mon, Jul 6, 2020 at 8:32 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> test=# create table MYÉCLASS (f1 text);
> CREATE TABLE
> test=# \dt
> List of relations
> Schema | Name | Type | Owner
> --------+----------+-------+----------
> public | myÉclass | table | postgres
> (1 row)
>
> pg_dump will render this as
>
> CREATE TABLE public."myÉclass" (
> f1 text
> );
>
> If we start to case-fold É, then the only way to access this table will
> be by double-quoting its name, which the application probably is not
> expecting (else it would have double-quoted in the original CREATE TABLE).

While this is true, it's also pretty hard to imagine a user being
satisfied with a table that ends up with this kind of mixed-case name.

That's not to say that I have any good idea what to do about this. I
just disagree with labelling the above case as a success.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company