Bug: psql misquotes constraints

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")

Responses

Browse pgsql-hackers by date

  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