Re: Some more information_schema issues

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: Some more information_schema issues
Дата
Msg-id
3F900AF2.4030000@familyhealth.com.au
Ответ на
Список
Дерево обсуждения
Some more information_schema issues Tom Lane <tgl@sss.pgh.pa.us>
Re: Some more information_schema issues Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Some more information_schema issues Tom Lane <tgl@sss.pgh.pa.us>
Re: Some more information_schema issues Tom Lane <tgl@sss.pgh.pa.us>
Re: Some more information_schema issues Peter Eisentraut <peter_e@gmx.net>
Re: Some more information_schema issues Tom Lane <tgl@sss.pgh.pa.us>
Re: Some more information_schema issues Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Some more information_schema issues Tom Lane <tgl@sss.pgh.pa.us>

>>True.  Btw., is there a particular value in pg_get_constraintdef always
>>printing double pairs of parentheses for CHECK constraints?
> 
> 
> No, but it will require some restructuring of the code to get rid of it
> safely (where "safely" is defined as "never omitting any parentheses
> that *are* necessary").  For the moment I'm willing to live with the
> ugliness.  You could consider pretty-printing (pass true to
> pg_get_constraintdef) if you think visual appeal is better than
> assured correctness.

We could check the first character of the definition, and if it isn't a 
left parenthesis, then we add parentheses.

Chris


В списке pgsql-hackers по дате отправления
От: Rod Taylor
Дата:
От: Shridhar Daithankar
Дата:
FAQ