public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Jim C. Nasby <[email protected]>
Cc: [email protected]
Subject: Re: CONSTRAINT syntax in ALTER TABLE
Date: Tue, 3 Jan 2006 23:26:37 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

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
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: CONSTRAINT syntax in ALTER TABLE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox