BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

Поиск
Список
Период
Сортировка
От David Schmitt
Тема BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases
Дата
Msg-id 201102080719.p187JbmO008217@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5869
Logged by:          David Schmitt
Email address:      david@dasz.at
PostgreSQL version: 8.4.5
Operating system:   Windows 7
Description:        postgresql corrupts unquoted non-ascii chars in column
aliases
Details:

Example query:

  SELECT column as zurück FROM table;

results in corruption of the "ü" (umlaut u). This causes Npgsql to fail to
match up the columns in the result set (see
http://pgfoundry.org/tracker/?func=detail&aid=1010988&group_id=1000140&atid=
590) and pgadminIII doesn't display the alias in the result pane.

The same query works with the same tools against a 8.4.5 running on Debian
squeeze.

If the alias is quoted like this:

  SELECT column as "zurück" FROM table;

the query also works against the DB running on windows.

PS: I tried downloading the newest version of the one click installer for
windows from EnterpriseDB, and noticed that since recently that site
requires a registration :-(

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

Предыдущее
От: "Christopher Head"
Дата:
Сообщение: BUG #5868: Client ignores X.509 subject alternative name
Следующее
От: Cyril DE MURCIA
Дата:
Сообщение: Duplicate table name within the sme schema