Re: ALTER TABLE modifications

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ALTER TABLE modifications
Дата
Msg-id 20031114141732.GB23845@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: ALTER TABLE modifications  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: ALTER TABLE modifications  (Hannu Krosing <hannu@tm.ee>)
Re: ALTER TABLE modifications  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-patches
On Fri, Nov 14, 2003 at 08:59:05AM -0500, Dave Cramer wrote:

> I tried the current patch on a RC2 release, and I noticed one
> undesirable side affect.
>
> Modifying a column  moves it to the end. In high availability situations
> this would not be desirable, I would imagine it would break lots of
> code.

This is expected.  Doing otherwise would incur into a much bigger
performance hit.

Anyway, IMHO no code should use SELECT * in any case, which is the only
scenario where one would expect physical column order to matter, isn't
it?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La primera ley de las demostraciones en vivo es: no trate de usar el sistema.
Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: ALTER TABLE modifications
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: ALTER TABLE modifications