Re: [COMMITTERS] pgsql: Remove arbitrary ALTER TABLE .. ADD COLUMN restriction.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [COMMITTERS] pgsql: Remove arbitrary ALTER TABLE .. ADD COLUMN restriction.
Дата
Msg-id 17140.1296057932@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Remove arbitrary ALTER TABLE .. ADD COLUMN restriction.  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [COMMITTERS] pgsql: Remove arbitrary ALTER TABLE .. ADD COLUMN restriction.  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Jan 26, 2011 at 10:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This is not an "arbitrary restriction" because according to the SQL
>> standard those operations mean different things. �In the first case you
>> get a column filled with the default value, in the second case you get a
>> column filled with nulls. �And the latter case is the only one that
>> works properly with a rowtype.

> That's an untenable interpretation.

No, *your* interpretation is untenable.  The sequence of operations that
the previous coding allowed behaves the same for both the table and
rowtype instances.  The "shortcut" doesn't behave the same.

This was, I believe, discussed at length when the previous coding was
put in.  The fact that you and Noah haven't read the spec carefully
doesn't give you license to change it.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: SSI patch version 14
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: REVIEW: EXPLAIN and nfiltered