Re: alter table alter columns vs. domains - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: alter table alter columns vs. domains
Date
Msg-id 409A79E8.30106@pse-consulting.de
Whole thread Raw
In response to Re: alter table alter columns vs. domains  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: alter table alter columns vs. domains
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL pre-fork speedup