Re: ALTER TABLE modifications

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: ALTER TABLE modifications
Дата
Msg-id
Pine.LNX.4.44.0311141556360.4276-100000@peter.localdomain
Ответ на
Список
Дерево обсуждения
ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Hannu Krosing <hannu@tm.ee>
Re: ALTER TABLE modifications Bruce Momjian <pgman@candle.pha.pa.us>
Re: ALTER TABLE modifications Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Peter Eisentraut <peter_e@gmx.net>
Re: ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Peter Eisentraut <peter_e@gmx.net>
Re: ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Hannu Krosing <hannu@tm.ee>
Re: ALTER TABLE modifications Dave Cramer <pg@fastcrypt.com>
Re: ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Peter Eisentraut <peter_e@gmx.net>
Re: ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE modifications Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: ALTER TABLE modifications Peter Eisentraut <peter_e@gmx.net>
Re: ALTER TABLE modifications Hannu Krosing <hannu@tm.ee>
Re: ALTER TABLE modifications Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE modifications Dave Cramer <pg@fastcrypt.com>
Re: ALTER TABLE modifications Rod Taylor <pg@rbt.ca>
Re: ALTER TABLE modifications Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: ALTER TABLE modifications Hannu Krosing <hannu@tm.ee>
Re: ALTER TABLE modifications Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: ALTER TABLE modifications Hannu Krosing <hannu@tm.ee>
Re: ALTER TABLE modifications Peter Eisentraut <peter_e@gmx.net>
Rod Taylor writes:

> The method is rename old column, add new column, move data across, move
> or reform dependencies, drop old column.

I can do this by hand.  If we have an explicit command to do it, then it
needs to preserve the table schema.  Else, this feature would be mostly
useless and a certain source of complaints.

-- 
Peter Eisentraut   peter_e@gmx.net

В списке pgsql-patches по дате отправления
От: Rod Taylor
Дата:
Сообщение: Re: ALTER TABLE modifications
От: Rod Taylor
Дата:
Сообщение: Re: ALTER TABLE modifications
FAQ