Re: Bug: psql misquotes constraints - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Bug: psql misquotes constraints
Date
Msg-id 40EE0333.9060004@familyhealth.com.au
Whole thread Raw
In response to Bug: psql misquotes constraints  (Rod Taylor <pg@rbt.ca>)
Responses Re: Bug: psql misquotes constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: t-ishii@sra.co.jp
Date:
Subject: try this patch!
Next
From: Christopher Kings-Lynne
Date:
Subject: Weird new time zone