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...

Merlin 


Thu, 6 May 2004 11:55:29 -0400
"Merlin Moncure" <merlin.moncure@rcsonline.com>
alter table alter columns vs. domains
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, Pennsylvania 19073

Thu, 6 May 2004 12:17:38 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: alter table alter columns vs. domains
> > Is it feasible or practical to consider adding ALTER DOMAIN TYPE type?
> > (basically following the same rules as ALTER TABLE).  
> 
> 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?

Yes. This is something I was going to look at doing in the next release.



Thu, 06 May 2004 13:17:02 -0400
Rod Taylor <pg@rbt.ca>
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



Thu, 06 May 2004 19:46:16 +0200
Andreas Pflug <pgadmin@pse-consulting.de>
Re: alter table alter columns vs. domains
> Is it feasible or practical to consider adding ALTER DOMAIN TYPE type?
> (basically following the same rules as ALTER TABLE).  

I was _just_ about to ask that!

Chris

Fri, 07 May 2004 08:39:28 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: alter table alter columns vs. domains

Added to TODO:

        o Add ALTER DOMAIN TYPE


---------------------------------------------------------------------------

Rod Taylor wrote:
> > > Is it feasible or practical to consider adding ALTER DOMAIN TYPE type?
> > > (basically following the same rules as ALTER TABLE).  
> > 
> > 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?
> 
> Yes. This is something I was going to look at doing in the next release.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

-- 
  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, Pennsylvania 19073

Wed, 19 May 2004 22:07:49 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: alter table alter columns vs. domains