From: | ddebernardy(at)yahoo(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8266: Problem with \d and ::regclass when tables have utf8 chars in their name |
Date: | 2013-06-27 22:11:09 |
Message-ID: | E1UsKPF-0007da-Ff@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 8266
Logged by: Denis de Bernardy
Email address: ddebernardy(at)yahoo(dot)com
PostgreSQL version: 9.2.4
Operating system: OSX Lion
Description:
As identified in this StackOverflow thread:
---
# 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Degasperi | 2013-06-28 09:59:51 | Re: BUG #8260: problem with sequence and tablename |
Previous Message | Tom Lane | 2013-06-27 17:56:29 | Re: BUG #8257: Multi-Core Restore fails when containing index comments |