Re: CONSTRAINT syntax in ALTER TABLE

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