From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org>, "Rod Taylor" <pg(at)rbt(dot)ca>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: alter table alter columns vs. domains |
Date: | 2004-05-06 18:54:22 |
Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB34101AE0C@Herge.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 only gets exercised in cases involving inheritance.
Just a clarification: isn't ALTER DOMAIN the best place to do this?
IMHO, this is one of those rare cases were extending PostgreSQL beyond
the SQL spec is justified. Right now, as I understand it, the only way
to do these types of things is to bring down the RI rules for a short
time until the table manipulation is completed, which seems inelegant,
not to mention the convenience factor.
Plus, I see anything that encourages usage of domains as good thing, as
domains themselves are very good things (and quite underutilized by the
unwashed masses, I expect).
Merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2004-05-06 19:00:12 | Re: alter table alter columns vs. domains |
Previous Message | sdv mailer | 2004-05-06 18:40:57 | Re: PostgreSQL pre-fork speedup |