Date: Tue, 3 Jan 2006 20:12:29 -0600
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-docs@postgresql.org
Subject: Re: CONSTRAINT syntax in ALTER TABLE
Message-ID: <20060104021229.GI82560@pervasive.com>
References: <20060102214613.GM39326@pervasive.com>
	<200601030204.k0324p324245@candle.pha.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200601030204.k0324p324245@candle.pha.pa.us>
User-Agent: Mutt/1.5.11

On Mon, Jan 02, 2006 at 09:04:50PM -0500, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Maybe it's just me, but I find it annoying that the ALTER TABLE docs
> > say to look at the CREATE TABLE docs for info on CONSTRAINT syntax. ISTM
> > it would be much better to:
> > 
> > Include the docs in both places, or
> > Break constraint syntax/info into it's own page
> > 
> > A last-resort would be to still refer to CREATE TABLE, but at least make
> > it link to the actual constraint section, instead of just linking to the
> > top of the page as it does now.
> 
> I like that last idea.  I don't think duplicate documentation or a
> separate section are a win.

By #2 I assume you mean my 'last resort'. One thing I dislike about that
is (I assume) it would do nothing to help \h ALTER TABLE in psql. Maybe
a good compromise would be to include the table_constraint section of
the CREATE TABLE syntax in the ALTER TABLE syntax.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461