Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 38C3E9FB6C6 for ; Tue, 29 May 2007 18:19:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99661-04 for ; Tue, 29 May 2007 18:19:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from p02c11o146.mxlogic.net (p02c11o146.mxlogic.net [208.65.144.79]) by postgresql.org (Postfix) with ESMTP id E47839FB69C for ; Tue, 29 May 2007 18:19:49 -0300 (ADT) Received: from unknown [208.65.151.10] (EHLO p02c11o146.mxlogic.net) by p02c11o146.mxlogic.net (mxl_mta-5.0.0-2) with ESMTP id 5f89c564.1808489392.566941.00-504.p02c11o146.mxlogic.net (envelope-from ); Tue, 29 May 2007 15:19:49 -0600 (MDT) Received: from unknown [208.65.151.10] (EHLO mxlhq-exch01.corp.mxlogic.com) by p02c11o146.mxlogic.net (mxl_mta-5.0.0-2) with ESMTP id 2f89c564.1923877808.566935.00-011.p02c11o146.mxlogic.net (envelope-from ); Tue, 29 May 2007 15:19:46 -0600 (MDT) Received: from 10.30.1.68 ([10.30.1.68]) by mxlhq-exch01.corp.mxlogic.com ([10.30.0.246]) via Exchange Front-End Server webmail.mxlogic.com ([10.30.0.241]) with Microsoft Exchange Server HTTP-DAV ; Tue, 29 May 2007 21:19:44 +0000 Received: from MXLRMT-208 by webmail.mxlogic.com; 29 May 2007 15:19:59 -0600 Subject: Re: ALTER TABLE - ALTER COLUMN question From: Keaton Adams Reply-To: kadams@mxlogic.com To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <17811.1180473419@sss.pgh.pa.us> References: <1180471333.19986.13.camel@MXLRMT-208.corp.mxlogic.com> <17811.1180473419@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="=-+remUiCf1KFisK3/qpgp" Organization: MX Logic, Inc. Date: Tue, 29 May 2007 15:19:59 -0600 Message-Id: <1180473599.19986.15.camel@MXLRMT-208.corp.mxlogic.com> Mime-Version: 1.0 X-Mailer: Evolution 2.10.1 X-Spam: [F=0.0100000000; S=0.010(2007050201); SS=0.500] X-MAIL-FROM: X-SOURCE-IP: [208.65.151.10] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.109 tagged_above=0 required=5 tests=AWL=-0.837, BAYES_50=0.001, DNS_FROM_RFC_WHOIS=1.447, HTML_40_50=0.496, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001 X-Spam-Level: * X-Archive-Number: 200705/309 X-Sequence-Number: 25629 --=-+remUiCf1KFisK3/qpgp Content-Type: text/plain Content-Transfer-Encoding: 7bit After I sent my request I found the notes related to ALTER TABLE on page 1,331 of the 8.1 manual, so that helped to explain it. Your reply to my post confirmed what I thought I was reading. Thanks for the reply, Keaton On Tue, 2007-05-29 at 17:16 -0400, Tom Lane wrote: > Keaton Adams 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 --=-+remUiCf1KFisK3/qpgp Content-Type: text/html; charset=utf-8 After I sent my request I found the notes related to ALTER TABLE on page 1,331 of the 8.1 manual, so that helped to explain it.  Your reply to my post confirmed what I thought I was reading.

Thanks for the reply,

Keaton



On Tue, 2007-05-29 at 17:16 -0400, Tom Lane wrote:
Keaton Adams <kadams@mxlogic.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
--=-+remUiCf1KFisK3/qpgp--