Skip site navigation (1) Skip section navigation (2)

Re: alter-table.sgml and DEFAULT clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: alter-table.sgml and DEFAULT clause
Date: 2010-12-28 15:21:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Excerpts from Fujii Masao's message of mar dic 28 01:26:09 -0300 2010:
>> We seem to have forgotten to add the reference to DEFAULT clause
>> into the following syntax in alter-table.sgml. How about the attached
>> patch?
>> ADD [ COLUMN ] column type [ column_constraint [ ... ] ]

> Hmm, and this works all the way back to 8.2 ...

I wonder whether it would be better to leave ALTER alone and change the
CREATE syntax diagram to fold DEFAULT in as one of the column_constraint
options.  The current syntax diagram is flat out wrong, because it
states that DEFAULT must precede any constraint phrase, which isn't so.
Copying that error into the ALTER syntax doesn't seem like a good fix
to me.

Probably the reason it's like it is is that somebody felt that DEFAULT
didn't seem like a kind of constraint.  While that doesn't bother me
especially, we could perhaps deal with that objection by renaming the
"column_constraint" nonterminal to some other phrase, like
"column_property" or "column_option".

			regards, tom lane

In response to

pgsql-docs by date

Next:From: Robert HaasDate: 2010-12-29 11:45:33
Subject: Re: Words missing in the following txt
Previous:From: Alvaro HerreraDate: 2010-12-28 13:09:41
Subject: Re: alter-table.sgml and DEFAULT clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group