Re: Bug: psql misquotes constraints

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug: psql misquotes constraints
Date: 2004-07-12 06:55:54
Message-ID: 40F235FA.5050408@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2004-07-12 07:18:35 Re: Statistical Lacunae in Interval type
Previous Message Oleg Bartunov 2004-07-12 06:44:04 Re: plperl (7.5)