From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200601040426.k044Qb614190@candle.pha.pa.us>
Subject: Re: CONSTRAINT syntax in ALTER TABLE
In-Reply-To: <20060104021229.GI82560@pervasive.com>
To: "Jim C. Nasby" <jnasby@pervasive.com>
Date: Tue, 3 Jan 2006 23:26:37 -0500 (EST)
CC: pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Jim C. Nasby wrote:
> 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

Yes, sorry.

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

If they created the table, they have already seen the constraint syntax.
I see no reason to repeat it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073