Re: ALTER TABLE - ALTER COLUMN question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kadams(at)mxlogic(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ALTER TABLE - ALTER COLUMN question
Date: 2007-05-29 21:16:59
Message-ID: 17811.1180473419@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Keaton Adams <kadams(at)mxlogic(dot)com> writes:
> In this example the created and msg_datetime columns are currently
> defined as TIMESTAMP WITHOUT TIME ZONE and no default. If the alter
> table for these changes is not in-place then I would want to run it as a
> single alter with all of the changes, such as this, instead of
> individual alters for each change, correct? (Because each individual
> alter would require another table copy?)

That's why ALTER TABLE has the ability to do more than one thing in
parallel ...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keaton Adams 2007-05-29 21:19:59 Re: ALTER TABLE - ALTER COLUMN question
Previous Message Keaton Adams 2007-05-29 20:42:13 ALTER TABLE - ALTER COLUMN question