Re: alter table alter columns vs. domains

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: alter table alter columns vs. domains
Date: 2004-05-06 19:00:12
Message-ID: 1083870012.91282.40.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

I don't think we need to allow end users to do it via the grammar.
Allowing an ALTER TYPE or ALTER DOMAIN to set up the multiple table
transform is enough.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2004-05-06 19:02:02 Re: ALTER TABLE TODO items
Previous Message Merlin Moncure 2004-05-06 18:54:22 Re: alter table alter columns vs. domains