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

From Bruce Momjian
Subject Re: Bug: psql misquotes constraints
Date
Msg-id 200407120057.i6C0v8D21995@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug: psql misquotes constraints  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Bug: psql misquotes constraints  (Rod Taylor <pg@rbt.ca>)
Re: Bug: psql misquotes constraints  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
I can do that for 7.6.  Is it worth it?  Is it a TODO?


---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> > 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: Status report
Next
From: Bruce Momjian
Date:
Subject: Re: patch for allowing multiple -t options to pg_dump