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

From Greg Stark
Subject Re: Bug: psql misquotes constraints
Date
Msg-id 871xjhohxu.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Bug: psql misquotes constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bug: psql misquotes constraints  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

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

-- 
greg



pgsql-hackers by date:

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