Re: Some more information_schema issues - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Some more information_schema issues
Date
Msg-id 3F900AF2.4030000@familyhealth.com.au
Whole thread Raw
In response to Re: Some more information_schema issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Some more information_schema issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>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 by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum
Next
From: Shridhar Daithankar
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum