Re: multibyte-character aware support for function "downcase_truncate_identifier()"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: multibyte-character aware support for function "downcase_truncate_identifier()"
Дата
Msg-id 438.1290386328@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: multibyte-character aware support for function "downcase_truncate_identifier()"  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: multibyte-character aware support for function "downcase_truncate_identifier()"  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Sun, Nov 21, 2010 at 6:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> spec compliance aside, we know from bitter experience that we cannot use
>> a definition that lets the Turkish locale fool with the mapping of i/I.
>> I suspect that locale-dependent mappings of any other characters are
>> just as bad, we simply haven't had enough users burnt by such cases to
>> have an institutional memory of it. �But for example do you really think
>> it's a good idea if pg_dump and reload into a DB with a different locale
>> results in changing the normalized form of SQL identifiers?

> No, especially if it results in queries that used to work breaking,
> which it well could.  But I'm not sure where to go with it from there,
> beyond throwing up my hands.

Well, that's why there's been no movement on this since 2004 :-(.  The
amount of work needed for a better solution seems far out of proportion
to the benefits.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Tab completion for view triggers in psql
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: Extensions, this time with a patch