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 ---
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 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.
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
On Thu, 2004-05-06 at 13:23, Merlin Moncure wrote:
Yes. This is something I was going to look at doing in the next
release.
Quick question:
With your potential changes, you would then be able to alter a domain
that is involved in RI constraints between 2 or more tables without
bringing
Yes. This is something I was going to look at doing in the next
release.
Quick question:
With your potential changes, you would then be able to alter a domain
that is involved in RI constraints between 2 or more tables without
bringing down the constraints, yes? This would be great :)
Merlin
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
Rod Taylor [EMAIL PROTECTED] writes:
With your potential changes, you would then be able to alter a domain
that is involved in RI constraints between 2 or more tables without
bringing down the constraints, yes? This would be great :)
I had been hoping to get away without actually rechecking
Tom Lane wrote:
If we were willing to abuse the ALTER TABLE syntax some more, it would
be possible to support changing the datatypes of f1 and f2
simultaneously, thereby allowing the above to work. The
infrastructure
for hacking multiple tables in parallel is already there in CVS tip,
but it
If we were willing to abuse the ALTER TABLE syntax some more, it would
be possible to support changing the datatypes of f1 and f2
simultaneously, thereby allowing the above to work. The infrastructure
for hacking multiple tables in parallel is already there in CVS tip,
but it only gets
Merlin Moncure [EMAIL PROTECTED] writes:
Tom Lane wrote:
If we were willing to abuse the ALTER TABLE syntax some more, it would
be possible to support changing the datatypes of f1 and f2
simultaneously, thereby allowing the above to work.
Just a clarification: isn't ALTER DOMAIN the best
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
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
12 matches
Mail list logo