On Mon, Jul 6, 2020 at 8:32 PM Tom Lane <t...@sss.pgh.pa.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
