Re: change natural column order - Mailing list pgsql-general

From Russell Smith
Subject Re: change natural column order
Date
Msg-id 200412011646.47132.mr-russ@pws.com.au
Whole thread Raw
In response to Re: change natural column order  (Greg Stark <gsstark@mit.edu>)
Responses Re: change natural column order
List pgsql-general
Regarding the "Natural Order" of columns.

Why if we can delete a column from the middle of a table now, change the type of that column to something totally
different,eg text -> int. 
Can we not move the order of the rows around, and when the new row is written to disk in the new arrangement.  Or more
accurately,
why is it not possible to add a new column, not at the end of the list.  It's probably more complicated that I think,
asthat's usually the case. 

We don't need logical and physical mapping, probably just the ability to insert a column not on the end.

Sorry if this comment is in the wrong place, I've been following the General and Hackers discussions and decided to
postnow after 
deleting the other posts.

Regards

Russell Smith.

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Next
From: Tom Lane
Date:
Subject: Re: Using default tablespace for database?