Re: alter table alter columns vs. domains

Bruce Momjian wrote:

>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?
>  
>
Hm, how about ALTER TYPE then?
IMHO domains as well as types are a bit too basic to change later on.

Regards,
Andreas