Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: alter table alter columns vs. domains
Date
Msg-id 200405061617.i46GHci02356@candle.pha.pa.us
Whole thread Raw
In response to alter table alter columns vs. domains  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: alter table alter columns vs. domains  (Rod Taylor <pg@rbt.ca>)
Re: alter table alter columns vs. domains  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: ALTER TABLE TODO items
Next
From: sdv mailer
Date:
Subject: Re: PostgreSQL pre-fork speedup