Re: alter table alter columns vs. domains

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: alter table alter columns vs. domains
Дата
Msg-id 200405061617.i46GHci02356@candle.pha.pa.us
обсуждение исходный текст
Ответ на alter table alter columns vs. domains  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Ответы Re: alter table alter columns vs. domains
Re: alter table alter columns vs. domains
Список pgsql-hackers
Merlin Moncure wrote:
> Is it feasible or practical to consider adding ALTER DOMAIN TYPE type?
> (basically following the same rules as ALTER TABLE).  
> 
> I don't mind bringing down all the views before I do this, it would be
> just great if you could change domains from a centralized location.
> Oracle offers this feature...

Interesting ---  you would have to rebuild every table that uses the
domain, and map from-to for all stored values of the domain.

TODO item?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: ALTER TABLE TODO items
Следующее
От: sdv mailer
Дата:
Сообщение: Re: PostgreSQL pre-fork speedup