Re: Bug: psql misquotes constraints

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Bug: psql misquotes constraints
Дата
Msg-id 40F1EA7D.8020006@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Bug: psql misquotes constraints  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Bug: psql misquotes constraints
Re: Bug: psql misquotes constraints
Список pgsql-hackers
It should be done, otherwise you cannot copy and paste foreign key 
creation code from the psql output :)

Chris

Bruce Momjian wrote:

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Removing initlocation
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Bug: psql misquotes constraints