Re: CONSTRAINT syntax in ALTER TABLE

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073