BUG #8266: Problem with \d and ::regclass when tables have utf8 chars in their name

Поиск
Список
Период
Сортировка
От ddebernardy@yahoo.com
Тема BUG #8266: Problem with \d and ::regclass when tables have utf8 chars in their name
Дата
Msg-id E1UsKPF-0007da-Ff@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8266
Logged by:          Denis de Bernardy
Email address:      ddebernardy@yahoo.com
PostgreSQL version: 9.2.4
Operating system:   OSX Lion
Description:

As identified in this StackOverflow thread:



http://stackoverflow.com/questions/17353469/postgresql-and-unicode-table-names-why-can-i-not-select-the-table-name-from-the/


---


# create table pinkƒpink1 (id serial);
NOTICE:  CREATE TABLE will create implicit sequence "pink?pink1_id_seq" for
serial column "pink?pink1.id"
CREATE TABLE
# select 'pinkƒpink1'::name;
    name
------------
 pinkƒpink1
(1 row)


# select 'pinkƒpink1'::regclass;
  regclass
-------------
 "pinkpink1"
(1 row)


# select relname from pg_class where oid = 'pinkƒpink1'::regclass;
  relname
-----------
 pinkpink1


# select relname from pg_class where relname = 'pinkƒpink1'::name;
 relname
---------
(0 rows)


# select relname from pg_class where relname = 'pinkpink1';
 relname
---------
(0 rows)


---


It doesn't seem to affect Debian.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8257: Multi-Core Restore fails when containing index comments
Следующее
От: Daniel Degasperi
Дата:
Сообщение: Re: BUG #8260: problem with sequence and tablename