Re: ALTER TABLE modifications - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: ALTER TABLE modifications
Date
Msg-id 20031114141732.GB23845@dcc.uchile.cl
Whole thread Raw
In response to Re: ALTER TABLE modifications  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: ALTER TABLE modifications  (Hannu Krosing <hannu@tm.ee>)
Re: ALTER TABLE modifications  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Dave Cramer
Date:
Subject: Re: ALTER TABLE modifications
Next
From: Hannu Krosing
Date:
Subject: Re: ALTER TABLE modifications