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

From Christopher Kings-Lynne
Subject Re: Bug: psql misquotes constraints
Date
Msg-id 40F235FA.5050408@familyhealth.com.au
Whole thread Raw
In response to Re: Bug: psql misquotes constraints  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
>>Since when was that a design goal for psql's \d output?  We had better
>>revert the entire pretty-printing patch if you expect this sort of thing
>>to work reliably.  I thought the point of \d formatting was to be
>>readable, not to be technically the exact same SQL you'd need to enter.
> 
> Hm, I always assumed it would work. It always did modulo quoting issues around
> $n.
> 
> It's certainly inconvenient if it doesn't given that there's no supported way
> to disable a particular constraint and then reenable it later without having
> the source available.

One thing that would be nice about using fmtId in psql is that names 
that DON'T need to be quoted would not be quoted.

Chris



pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: plperl (7.5)
Next
From: Peter Eisentraut
Date:
Subject: Re: Statistical Lacunae in Interval type