From: | Rod Taylor <pg(at)rbt(dot)ca> |
---|---|
To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Bug: psql misquotes constraints |
Date: | 2004-07-08 16:24:21 |
Message-ID: | 1089303861.5999.186.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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")
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2004-07-08 17:33:56 | Re: PITR Redo Create Database fails |
Previous Message | Alvaro Herrera | 2004-07-08 15:19:33 | Re: PITR Redo Create Database fails |