Re: change natural column order

Поиск
Список
Период
Сортировка
От Russell Smith
Тема Re: change natural column order
Дата
Msg-id 200412011646.47132.mr-russ@pws.com.au
обсуждение исходный текст
Ответ на Re: change natural column order  (Greg Stark <gsstark@mit.edu>)
Ответы Re: change natural column order  (Tino Wildenhain <tino@wildenhain.de>)
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using default tablespace for database?