Re: Bug: psql misquotes constraints

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug: psql misquotes constraints
Date: 2004-07-09 02:30:11
Message-ID: 40EE0333.9060004@familyhealth.com.au
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.

It's misquoted because psql DOES NOT share the fmtId function with
pg_dump. It simply puts double quotes around it. If you can fix psql
so that it is able to link to the fmtId function, then you can easily
fix the problem.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-07-09 03:49:08 Weird new time zone
Previous Message t-ishii 2004-07-09 00:49:24 try this patch!