Alvaro Herrera kirjutas R, 14.11.2003 kell 16:17:
> 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.

Not neccessarily, but it would make the patch much bigger ;)

IIRC there was discussion about splitting colum numbers into physical
and logical numbers at the time when DROP COLUMN was done.

> 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?

and this could also break when just changing the column type.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to