Bug: psql misquotes constraints
| От | Rod Taylor |
|---|---|
| Тема | Bug: psql misquotes constraints |
| Дата | |
| Msg-id | 1089303861.5999.186.camel@jester обсуждение исходный текст |
| Ответы |
Re: Bug: psql misquotes constraints
|
| Список | pgsql-hackers |
As a result of the constraint output functions being shared between
pg_dump and psql, some of the output is mis-quoted in the display area
for columns including quotes. Notice it's correct in the table Column
list, but the constraint has the escaped versions.
Thoughts?
rt=# create table c ("""vers""ion""" integer unique references a);
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"c_"vers"ion"_key" for table "c"
CREATE TABLE
rt=# \d c Table "public.c" Column | Type | Modifiers
------------+---------+-----------"vers"ion" | integer |
Indexes: "c_"vers"ion"_key" unique, btree ("""vers""ion""")
Foreign-key constraints: "$1" FOREIGN KEY ("""vers""ion""") REFERENCES a("version")
В списке pgsql-hackers по дате отправления: