Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results
Дата
Msg-id 1083.1006925780@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> So, are we now all agreed that we have to fill in the existing rows with
> the default value?

I think there's no debate that that's what the spec says to do.  There
might be some discontent in the ranks about whether to follow SQL92's
marching orders, however.  Doubling the filesize of the table to apply
changes that the user might not even want seems a heavy penalty.

> If so, I can document that in the TODO list and
> discard this patch.

This is certainly a TODO or TOARGUEABOUT item, not something to be
patched on short notice.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Call for platform testing