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.