Thread: BUG #8266: Problem with \d and ::regclass when tables have utf8 chars in their name
BUG #8266: Problem with \d and ::regclass when tables have utf8 chars in their name
From
ddebernardy@yahoo.com
Date:
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.