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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend